January 24, 2013 at 3:59 am
What is the procedure to delete some data from Lock Table?
We can't use NOLOCK for Update, delete & Insert for that.
A table Name like Business_History which is in Transaction Lock.
Want to delete data where Proposal_Form_No='ABC'. If I Execute Select Operation With NOLOCK it shows 5 rows of data. But Can't delete them.
Please Help.:(
January 24, 2013 at 4:17 am
check with sp_who2 , which spid is locking that table
then for all fetched do dbcc inputbuffer(sp_id), see what kind of transaction is there
then decide which spid you can kill
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 24, 2013 at 4:18 am
just came to know that this is duplicate post.
it wastes poeple time , dont cross post.
original post http://www.sqlservercentral.com/Forums/Topic1411020-391-1.aspx#bm1411043
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply