Paul White (2/17/2010)
With an exclusive lock, no other transactions can modify data (except for operations with NOLOCK hint or read uncommitted isolation level)What???!!! :w00t:
I want my point back!
Unless someone can post code or a reference to show that NOLOCK or READ UNCOMMITTED allows modification of data protected by an exclusive lock!
Grrr!
I agree with you. I happened to find the article that discusses this and was sure that that option was just a typo and poorly written. So I still selected it - :w00t:
It should be:
read operations can take place only with the use of the NOLOCK hint or read uncommitted isolation level.
This is the only part of the question that I took issue with and am glad that others saw the same thing.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events