Lock in Tempdbgreenspun.com : LUSENET : SQL Server Database Administration : One Thread |
Hi I have a lock in my tempdb. I am not able to kill that it is an details is as follows Process ID Lock Type Mode Status Owner Index Resource 51 TAB X GRANT Xact ##lockinfo51 How can I remove thisTIA
Renjith
-- Anonymous, December 25, 2003
Renjith,I would try (as sa):
kill 51
If that did not work, I would bounce the SQL Server.
Hope this helps,
Eric
-- Anonymous, January 05, 2004