• pallab.santra1987 (1/24/2013)


    For SQL Server 2008:

    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.:(

    Seriously ?


    Sujeet Singh