All Questions
2 questions
2
votes
2
answers
268
views
SQLCLR User-Defined Type (UDT) SCH-M blocking
I’m hoping someone can provide some guidance on a problem I’m having with schema locking on C# SQLCLR UDT’s. I’ve been on the Internet for an extended period of time researching my problem without ...
1
vote
0
answers
2k
views
LCK_M_SCH_M Blocking
I have 2 stored procedures (one vendor, one third party) that are constantly (monthly) stepping on each other. They both (for some reason) acquire a schema lock when all they are doing is updating ...