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 |
|
bertnz
Starting Member
1 Post |
 Posted - 2007-10-18 : 20:55:24
|
| Hi,I have a fairly complex application running which has numerous connections on various threads accessing my sql 2005 database.Every now and then I find that one of my connections is being blocked by process with a pid of -2.I assume this is some system process.The only way I can get my application going again is to restart the sql server.Can someone tell me what process -2 is?cheers,Robert |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-18 : 21:17:13
|
| What does DBCC INPUTBUFFER(spidNumberGoesHere) show?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-18 : 22:53:29
|
| spid should have positive number. |
|
|
|
|
|
|
Connection blocked by process -2