All queries take a shared database lock, to ensure that the DB doesn't disappear out from underneath them. Exclusive DB lock? That should be limited to db reconfigurations & setting changes
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass