SQL Deadlock Issues

Last Post 24 May 2006 09:40 AM by ag19702004. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ag19702004
New Member
New Member

--
24 May 2006 09:40 AM
Hi

I am having issues when the same SQL queries run simultaneously from diiferent ASP App threads is getting deadlocked.

The deadlock is for a query, which calls a Stored Proc. The stored Proc has a transaction, inside of which it does the following

Alter Proc DoSomething
BEING
BEGIN TRANSACTION TRAN1
SELECT * from TABLEA -- captures values in local variables
DELETE from TABLEA
INSERT into TABLEB -- values captured from TABLEA
COMMIT TRANSACTION TRAN1
SELECT @V1, @V2 from TABLEA -- same as in first step
END

It is the DELETE that is causing a Deadlock

Would really appreciate help on this

Thanks
Alvin
You are not authorized to post a reply.

Acceptable Use Policy