x

sp_getschemalock is causing the lock of database servers

The procedure sp_getschemalock is causing the lock of database servers arbitrarily. What is the reason for this blockade? How to avoid it?

more ▼

asked Nov 06, 2009 at 01:06 PM in Default

avatar image

André Mendonca
11 1 1 3

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

a quick google revealed

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/231b4893-7bf6-4b7b-b072-1338d95c3eeb/

Are you using ssis ?, how is sp_getschemalock being called , and by what ?

more ▼

answered Nov 06, 2009 at 04:49 PM

avatar image

dave ballantyne
928 1 3 6

(comments are locked)
10|1200 characters needed characters left

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?

more ▼

answered Nov 06, 2009 at 01:13 PM

avatar image

Kev Riley ♦♦
63.8k 48 61 81

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x273
x30

asked: Nov 06, 2009 at 01:06 PM

Seen: 5671 times

Last Updated: Nov 06, 2009 at 01:06 PM

Copyright 2016 Redgate Software. Privacy Policy