Home Forums SQL Server 2005 Administering SNAPSHOT Isolation with (NOLOCK) being used all over RE: SNAPSHOT Isolation with (NOLOCK) being used all over

  • Paul, that was my whole point to him as well. I'm still fairly new over here, so trying not to rock the boat too much.

    Also - if either you or Gail might know this, I would appreciate it. Is there a query that I could run against some of the system objects that would retrieve a time/date stamp for me of when the Isolation Level was set or changed? There is this paranoid theory that someone did this without approval, and they are just wanting to see if there is a way to tell via a time date stamp. I have not found anything to date that will retrieve this from T-SQL, but if you might know - I would appreciate it (I asked this in another thread but to date have no response to it).