SQL Server Performance

SQL server reports a -2 on non distributed process

Discussion in 'General DBA Questions' started by netscriptions, Feb 28, 2005.

  1. netscriptions New Member

    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

Share This Page