@@TranCount

It returns the number of active transaction in current connection.

When transaction within a transaction starts, it increase @@TranCount by 1. COMMIT and ROLLBACK decrease @@TranCount by 1 except for ROLLBACK TRANSACTION <savepoint_name>, which does not affect @@TRANCOUNT.

 - facebook_page