The procedure sp_getschemalock is causing the lock of database servers arbitrarily. What is the reason for this blockade? How to avoid it?
asked Nov 06 '09 at 01:06 PM in Default
a quick google revealed
Are you using ssis ?, how is sp_getschemalock being called , and by what ?
answered Nov 06 '09 at 04:49 PM
sp_getschemalock is an internal extended procedure, used when querying across linked servers.
Does this fit with your scenario?
If so what queries are you running?
answered Nov 06 '09 at 01:13 PM
Kev Riley ♦♦