Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008

    Question Unanswered: MS SQL Server 2000: locked record problem

    Hello, I've got a problem with Ms Sql Server 2000. Last day, a C++ application crashed while accessing the database. After that, several records can't be updated using this application. However, they can be modified directly using the Enterprise Manager. We have restarted the sql server to release all blocked entries listed on the current activity section of the Enterprise Manager. We have restored the database too from a previous backup. None of these actions worked, those records remains locked and it is so rare because we don't know how this persistent locks work.


  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    My first guess would be that there is something in the database, either in the rows that are affected or possibly some related rows that is causing this locking.

    I've also seen similar behavior in application servers and via data cached on the client (in cookies or registry entries), but those have become quite rare over time.


  3. #3
    Join Date
    Aug 2005
    so sp_lock doesn't show anything?

    Can you Select the data directly via T-SQL query (I would assume so if you can view via EM)?

    what about something like this? (though this might be a bit extreme)

    select * into TableName_TEMP from TableName

    script out the DDL of TableName

    drop TableName

    set identity_insert TableName on

    insert TableName
    select * from TableName_Temp

    set identity_insert TableName off

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts