Record Lock on Database will not go away
How do I find out who has it locked.
1. A LDB will also get left behind if a user abnormally disconnects from the DB. As Pat said, all users should have delete priv's. Check this and then if the LDB continues to get left behind, you've got other issues.
2. It is possible to release the lock on the LDB without rebooting the server. If it's a network connection, you just have to close the session. That's done from Computer Managernt, Files and Shares.
If the lock is from a local logon, then you would need to use something like process Explorer that can find the handle and kill it.
Jim.
Gain unlimited access to on-demand training courses with an Experts Exchange subscription.
Get AccessWhy Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions