Urgent Question

[SQLBaby]

My hard drive is full and i got the locks, i removed some data from hard drive so i have space now but i can not see the locks. When i press current activity its showing no item and when i try to refresh i get this wrror. Error 1222-Lock request time out period exded.

Any ide how to release the locks

Knowledge is a key of success.

 

[JayKusch]

May not be a space issue. First check the size of your TempDB but also look at this article ...

http://www.microsoft.com/sql/techinfo/tips/development/blockedconnection.asp

Thanks

J. Kusch