@@TRANCOUNT

@@TRANCOUNT

 

@@TRANCOUNT Command returns no of active transactions in current connection / session

 

PRINT '@@TRANCOUNT'

PRINT @@TRANCOUNT

BEGIN TRAN

      PRINT 'FIRST TRANSCTION STARTED'

      PRINT 'OPEN TRANSCTION : '

      PRINT @@TRANCOUNT

COMMIT

PRINT 'FIRST TRANSCTION ENDED'

PRINT 'NOW OPEN TRANSCTION : '

      PRINT @@TRANCOUNT