Orphaned MSDTC Transactions (-2 spids)

As cited in DDIA

Ajmer Dhariwal. "Orphaned MSDTC Transactions (-2 spids)." eraofdata.com, December 2008. Archived at perma.cc/YG6F-U34C

How the page describes itself

Orphaned MSDTC transactions (-2 spids) - Era of Data: Mostly just SQL Server stuff

SPIDS with a value of -2 Any dba looking after a server that takes part in a distributed transaction will probably have come across situations where a SPID that does not show up in master..sysprocesses or sys.dm_exec_sessions (depending on your version of SQL Server) ends up blocking other users. Looking at sp_lock or the syslockinfo table or sys.dm_tran_locks would show resources being locked by …

From the page's own metadata at eraofdata.com, 2026-08-29.

Link check

Status

Link checked and reachable (HTTP 200)

Format

text/html

Size

0.0 MB

Last checked

2026-08-29

Identifiers and archived copies

perma.cc

https://perma.cc/YG6F-U34C