InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 17:29:43 GMT20http://www.sqlservercentral.com/Forums/Topic1398680-391-1.aspxNo one ? :w00t: Not even Sean ? Gila ? GSquared ?Thu, 20 Dec 2012 08:58:30 GMTsqlGDBAhttp://www.sqlservercentral.com/Forums/Topic1398680-391-1.aspxI have a deadlock situation that I am having some difficulty understanding. Attached is the deadlock graph - I am trying to understand why we see so many metadata locks. Is a metadata lock the same as a Schema lock ? I think not, but the Object ID in the matadata lock actually belongs to a user table(not system tables/management views).I would appreciate any insights anyone may have as to what exactly a metadata lock is and why does SQL Server use them ?Wed, 19 Dec 2012 14:42:38 GMTsqlGDBA