How to detect READ_COMMITTED_SNAPSHOT is enabled?

Question

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

Answer 1

SELECT is_read_committed_snapshot_on FROM
sys.databases WHERE name= 'YourDatabase'