a Process locked a table (SQL 2000)
Posted on 2010-08-24
I have a SQL Server 2000 database that when the users came in Monday morning a table was locked and my users couldn't use my application. This application with the SQL backend database has been around for 9 years and we have never had this problem. The user who locked the table (who was off Monday) was the new computer guy for the department and he was admittedly playing with the database so he could become familiar with it. Note the computer guy is not a SQL Server person and was not writing procs but might have been doing queries or playing with the data in the table.
* I don’t understand how “a process” could lock a table. By locking a table (my terminology) the particular table if opened in Enterprise Manager would time out and not show any records. What I’m looking for is a couple of “SIMPLE” examples of how to lock a table so it would time out.
* I had to go through the DBA who I was lucky enough she wanted to work with me. Once we determined the problem she “Stopped the process” and all was fine. How do I see a locking process in Enterprise Manager 2000 and then stop it. (I don’t have the rights to Enterprise Manager on the live db but I would like to see it on my local copy [I manage the live db through an Access adp])
A little more info:
I'm a programmer that uses SQL Server but my expertise is with the front end not the backend.