need help regarding Lock Table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » need help regarding Lock Table

need help regarding Lock Table

Rate Topic

Display Mode

Topic Options

Author

Message

pallab.santra1987

Posted Thursday, January 24, 2013 3:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, January 24, 2013 5:43 AM
Points: 4, Visits: 5

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. Sad

Post #1411039

Bhuvnesh

Posted Thursday, January 24, 2013 4:17 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1411049

Bhuvnesh

Posted Thursday, January 24, 2013 4:18 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1411051

« Prev Topic | Next Topic »

Permissions