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
Any help with this would be really appreciated.
Thank you all in advance!