SQL Server Performance Forum – Threads Archive
SQL Server ProfilerWhen I run SQL Server Profiler (SQL Server 2005), I get a lot of SQLTransaction events and I see Begin, Commit, Rollback in the EventSubClass column. The thing I don’t understand is that I did not issue any transaction. The transaction settings are: set implicit_transactions off
set transaction isolation level read committed
some excerpts of BOL for Implicit Transactions Implicit transactions Set implicit transaction mode on through either an API function or the Transact-SQL SET IMPLICIT_TRANSACTIONS ON statement. The next statement automatically starts a new transaction. When that transaction is completed, the next Transact-SQL statement starts a new transaction. Connection modes are managed at the connection level. If one connection changes from one transaction mode to another it has no effect on the transaction modes of any other connection.
> "Read Comminted" is a default Isolation Level. Hemantgiri S. Goswami
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
Hi ghemant, Since the settings have Implicit Transaction off, I think that paragraph won’t apply in my case.
When OFF, it returns the connection to autocommit transaction mode.
Implicit transaction mode remains in effect until the connection executes a SET IMPLICIT_TRANSACTIONS OFF statement, which returns the connection to autocommit mode. In autocommit mode, all individual statements are committed if they complete successfully. http://msdn2.microsoft.com/en-us/library/ms187807.aspx Mohammed U.