Home Forums SQL Server 2005 Administering Locks from inactive spid???? RE: Locks from inactive spid????
spaghettidba
SSC Guru
Points: 105732
More actions
August 6, 2008 at 6:52 am
#853770
In Activity Monitor there's a column named "Open Transactions", that contained a 0 for my mysterious spid... I don't know where that information is extracted from, but I think I can rely on it.
-- Gianluca Sartori