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!
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi