Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Query to tell when Isolation level was set... Expand / Collapse
Posted Sunday, November 18, 2012 10:27 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, November 10, 2016 12:52 PM
Points: 520, Visits: 1,584
Hi -

I need a way to find out when an isolation level was last set on a database (or originally set and is the same since). Reason being is due to an issue right now at my place of business that is swearing we were using SNAPSHOT ISOLATION when in fact it is listed as the default - RED COMMITTED (and all of our code is indicative of the default because the use of WITH(NOLOCK) is everywhere.

I came up with this, but my feeling is that this is the creation date of the database, and not the last time the isolation level was set...

SELECT name, create_date, snapshot_isolation_state_desc, is_read_committed_snapshot_on 
FROM sys.databases

Any help with this would be really appreciated.

Thank you all in advance!

Post #1386149
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse