March 18, 2012 at 4:20 pm
Hello,
I am trying to determine how to tell if Implicit Transactions is turned on in one of our databases. I checked Tools --> Options --> Query Execution --> SQL Server --> ANSI and the 'Set Implicit Transactions' option is not checked. However I believe this setting can also be set at the server level as well? Let me know if you have any questions and thanks in advance.
March 19, 2012 at 1:03 am
You can specify the connection options at the server level.
Right-click on your server in the Object browser and select properties.
Go to Connections and you'll see Implicit Transactions in the list.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 19, 2012 at 1:04 am
Implicit transactions are a connection-level setting. It's set when a connection connects to SQL Server, not at the database or server level. What's set at the server level is the default connection options, but that's just default and can be overridden.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply