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.