Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 How to kill the unknow process!

Author  Topic 

raj4582
Starting Member

16 Posts

Posted - 2010-09-06 : 04:49:17
Hello,

When i am executing my query it's locked by unknown process (SPID -2). can anyone please let me know how to kill this process and why this is being locked.

SPID BlockingSPId
66 -2

Regards
Raj

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2010-09-06 : 06:13:07
See http://msdn.microsoft.com/en-us/library/aa933230(SQL.80).aspx



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page
   

- Advertisement -