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 this
-- Anonymous, December 25, 2003
I would try (as sa):
If that did not work, I would bounce the SQL Server.
Hope this helps,
-- Anonymous, January 05, 2004