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.
| Author |
Topic |
|
ranvir_2k
Posting Yak Master
180 Posts |
 Posted - 2011-08-26 : 07:25:57
|
| I'm seeing SPID -2 blocking some processes on my server. Is there any way to find out what this SPID is? and how do you go about killing it? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-26 : 08:01:48
|
| yep.tryDBCC inputbuffer(2)will give details of command its executing------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-26 : 08:04:24
|
| i question though. are you sure its spid 2?SQL Server reserves SPID values from 1 through 50 for internal use so I dont think thats a user process at all------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
ranvir_2k
Posting Yak Master
180 Posts |
Posted - 2011-08-26 : 08:26:46
|
| it's not SPID 2, it's -2. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
SPID -2