SQL Server table is locked

987 views Asked by At

I am trying to insert a record into a table, but I cannot. The execution never ends. I can do select though. I guess something locking my table? How can I find out what does it?

Thanks.

1

There are 1 answers

7
Shiva On BEST ANSWER

If you have the necessary permissions for the following, you can run then in SQL Server Management Studio (SSMS) to find out the processes that are locking tables.

sp_who
sp_who2
sp_lock

Then you can KILL the process in question by taking the Process ID from 1 of the above SPs.

-- Kill Server process ID 123
KILL 123