I am new to SQL Server thing. I am facing a problem with locking in SQL Server.
2 days back my all the DML statements were giving the timeout error. Using the Enterprise Manager I was able to find that there were 2 DB locks in the database.
Then after a day or so I found that one of them is automatically killed, but one is still there. But this time I am able to execute DML statements.
How this is possible. the lock was DB lock.
This is urgent. Thanks in advance..
In the enterprise manager, having admin rights, you can look at what is going on inside your SQL Server. The EM will show that the database has locks but you have to pay attention when it is blocked. In the EM under Management, refresh current activity and look at expand locks/Process ID. If you do not have (blocked) next to anything you are free to do what you need to do. Also you can open up Process info and gather more information as to who is holding the lock and the code represented.