trancount

What Is SQL Trancount? SQL Server Rider @@TRANCOUNT returns the count of open transactions in the current session. It increments the count value whenever we open a transaction and decrements the count whenever we commit the transaction. Rollback sets the trancount to zero and transaction with save point does to affect the trancount value. What