Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

need help regarding Lock Table Expand / Collapse
Author
Message
Posted Thursday, January 24, 2013 3:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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.
Post #1411039
Posted Thursday, January 24, 2013 4:17 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:16 AM
Points: 2,840, Visits: 3,983
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
Post #1411049
Posted Thursday, January 24, 2013 4:18 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:16 AM
Points: 2,840, Visits: 3,983
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
Post #1411051
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse