May 25, 2004 at 12:50 am
Hi
I have a SQL server 2000 sp3 - Datacentre platform with the following..
If there is an open transaction against the Database I connot browse the DB objects with EM or Query Analyser. I get a lock request time out. This means if the DB has explicit trans open I cannot get into the DB. These are not huge transactions and I commit often.
Any ideas about this behaviour?.....
Andy.
May 25, 2004 at 5:03 am
What is isolation level of your transaction and what resources it locking?
if
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
go
begin tran
insert into dbo.LSKLADI values(0,0,0,'qwe','qwe')
WAITFOR DELAY '00:00:20:000'
rollback tran
than in other connections I can't exec select * from dbo.LSKLADI
May 25, 2004 at 5:39 am
I am using the default - -READ COMMITTED
My problem is that the entire database gets locked. You cannot even browse the sp'S.
Andy.
May 25, 2004 at 7:37 pm
those locking issues are very common on cases where "select into" is used with long performing queries. My advice: Try to change those to INSERT INTO instead
HTH
* Noel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply