Friday, January 21, 2011

How to detect READ_COMMITTED_SNAPSHOT is enabled?

Hello, In MS SQL Server is there a way to detect whether a database has had its isolation level set via the T-SQL command ALTER DATABASE <database> SET READ_COMMITTED_SNAPSHOT ON;

I cannot find a simple way to detect this in either T-SQL or via the Management Studio's GUI.

TIA

  • SELECT is_read_committed_snapshot_on FROM
    sys.databases WHERE name= 'YourDatabase'
    
    From Galwegian

0 comments:

Post a Comment