Lock in Tempdb

greenspun.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

TIA

Renjith

-- Anonymous, December 25, 2003

Answers

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


Moderation questions? read the FAQ