Current Isolation Level | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Current Isolation Level


How do I know the current Isolation level of the DB?
dbcc useroptions doesnt show this
Madhivanan Failing to plan is Planning to fail
DBCC USEROPTIONS doesn’t show this when it’s on the default of "READ COMMITTED". Try this<br /><pre id="code"><font face="courier" size="2" id="code"><br />USE pubs<br />GO<br />SET TRANSACTION ISOLATION LEVEL REPEATABLE READ<br />GO<br />DBCC USEROPTIONS<br />GO<br /></font id="code"></pre id="code"><br />Btw, that’s an example from BOL. [<img src=’/community/emoticons/emotion-5.gif’ alt=’;)‘ />]<br /><br />–<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />Ich unterstuetze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)
Thanks. So If DBCC doesnt show this then it is READ COMMITTED [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
Committed Read is SQL Server’s default isolation level. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>