<p>In Microsoft SQL Server, is there a way to detect whether a database has had its isolation level set via the T-SQL command <code>ALTER DATABASE &lt;database&gt; SET READ_COMMITTED_SNAPSHOT ON;</code>?</p>
<p>I cannot find a simple way to detect this in either T-SQL or via the Management Studio's GUI.</p>

[{'answer_id': 51977, 'author': 'Galwegian', 'author_id': 3201, 'author_profile': 'https://Stackoverflow.com/users/3201', 'pm_score': 9, 'selected': True, 'text': '<pre><code>SELECT is_read_committed_snapshot_on FROM sys.databases \nWHERE name= \'YourDatabase\'\n</code></pre>\n<p>Return value:</p>\n<ul>\n<li><strong>1</strong>: <code>READ_COMMITTED_SNAPSHOT</code> option is <strong>ON</strong>. Read operations under the <code>READ COMMITTED</code> isolation level are based on snapshot scans and do not acquire locks.</li>\n<li><strong>0</strong> (default): <code>READ_COMMITTED_SNAPSHOT</code> option is <strong>OFF</strong>. Read operations under the <code>READ COMMITTED</code> isolation level use <a href="https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms175519(v=sql.105)" rel="noreferrer">Shared (S) locks</a>.</li>\n</ul>\n'}, {'answer_id': 20942633, 'author': 'user3164106', 'author_id': 3164106, 'author_profile': 'https://Stackoverflow.com/users/3164106', 'pm_score': 0, 'selected': False, 'text': '<p>Neither on SQL2005 nor 2012 does <code>DBCC USEROPTIONS</code> show <code>is_read_committed_snapshot_on</code>:</p>\n\n<pre><code>Set Option  Value\ntextsize    2147483647\nlanguage    us_english\ndateformat  mdy\ndatefirst   7\nlock_timeout    -1\nquoted_identifier   SET\narithabort  SET\nansi_null_dflt_on   SET\nansi_warnings   SET\nansi_padding    SET\nansi_nulls  SET\nconcat_null_yields_null SET\nisolation level read committed\n</code></pre>\n'}, {'answer_id': 38287052, 'author': 'MikeL', 'author_id': 6569861, 'author_profile': 'https://Stackoverflow.com/users/6569861', 'pm_score': 2, 'selected': False, 'text': '<ol>\n<li>As per <a href="https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-useroptions-transact-sql" rel="nofollow noreferrer">DBCC USEROPTIONS (Transact-SQL)</a>:</li>\n</ol>\n<blockquote>\n<p>DBCC USEROPTIONS reports an isolation level of \'read committed snapshot\' when the database option READ_COMMITTED_SNAPSHOT is set to ON and the transaction isolation level is set to \'read committed\'. The actual isolation level is read committed.</p>\n</blockquote>\n<ol start="2">\n<li>Also in SQL Server Management Studio, in database properties under Options-&gt;Miscellaneous there is &quot;Is Read Committed Snapshot On&quot; option status</li>\n</ol>\n'}]
['https://Stackoverflow.com/questions/51969', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/5217/']