SQL Server Performance Forum – Threads Archive
spid = -2
Hi allI had to checked syslockinfo table with this below query select * from syslockinfo rsc_text rsc_bin rsc_valblk rsc_dbid rsc_indid rsc_objid rsc_type rsc_flag req_mode req_status req_refcnt req_cryrefcnt req_lifetime req_spid req_ecid req_ownertype req_transactionID req_transactionUOW
——————————– ———————————- ———————————- ——– ——— ———– ——– ——– ——– ———- ———- ————- ———— ———– ———– ————- ——————– ————————————
0x00022B00000000000000000000000000 0x00000000000000000000000000000000 43 0 0 2 0 3 1 2 0 0 -2 0 1 231323357 5EC0A8E6-84AC-42AA-A667-4C10D6B021D6
0x00022B00000000000000000000000000 0x00000000000000000000000000000000 43 0 0 2 0 3 1 2 0 0 -2 0 1 231323616 F534C3A3-589A-420A-9E3B-75948F434838
0x00022B00000000000000000000000000 0x00000000000000000000000000000000 43 0 0 2 0 3 1 2 0 0 -2 0 1 231322771 468DB5C5-954F-403C-9C42-CCB6867F4A40
0x00022B00000000000000000000000000 0x00000000000000000000000000000000 43 0 0 2 0 3 1 2 0 0 -2 0 1 231322919 C3C32E97-4A72-4E55-88E7-2B5256238850
28 results
I got this result. i saw spid is -2. i dint understand. please help. i have try to run a procedure. its stuck at a particular query. i found that there is no blocks. Please help me Thanks
S. Ramesh
The artificial SPID -2 indicates an orphaned DTC Transaction. You can kill this transaction by executing KILL UOW Roji. P. Thomas
http://toponewithties.blogspot.com
yes. check this for more info
http://msdn2.microsoft.com/en-us/library/aa933230(sql.80).aspx —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
Ramesh
Is this in SQL 2000 or SQL 2005?
What kind of scheduled jobs are at that time? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>