Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lmhjob
Starting Member
1 Post |
 Posted - 2008-09-16 : 04:46:00
|
| 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.Thanks, Laura |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-09-16 : 09:36:26
|
do you have an "islocked" column in some table that the C++ app updated to true but then crashed and never put it back?
elsasoft.org |
 |
|
|
|
|
|
MS SQL Server 2000: persistent locked record