Sunday, May 30, 2010

Check current Isolation level in SQL Server

Often we wanted to know the current isolation level set for the SQL Server database. This can be easily checked with the following DBCC command.

DBCC USEROPTIONS;

This command returns the SET options active/configured for the current connection.

Result:

image

No comments:

Post a Comment