SQL Server Performance Forum – Threads Archive

SQL server reports a -2 on non distributed process

Hello guys,
We have had a situation on one of our servers that was very mysterious and I am hoping to get some help from someone to understand the situation. OK, here goes,
a. We are using SQL server 2000 SP4 on a W2K server
b. We have an insert trigger which calls a function withn the same database
c. I know SQL server renames a SPID as -2. When a distributed transaction loses one of its connection SQL server calls the orphan process -2.
d. The trigger and function are in the same database are NOT using a distributed transaction. They arent even using a transaction!!?!! We encountered a -2 on the trigger process and had to kill it manually.
Does anyone know of a bug or something that forces SQL server SPIDs to a -2? Regards,
Jayesh

---

]]>