You can use the @@TRANCOUNT function to determine whether any open transactions exist and how deeply they are nested.
A BEGIN TRANSACTION statement increments @@TRANCOUNT by one, and a ROLLBACK statement sets @@TRANCOUNT to zero.


The Role of Call Data: How Call Tracking Can Improve Customer Experience
Who would argue that experiences reign supreme? But not just any experiences — the ones that occur when customers interact with your business. It’s these real-life interactions that have the