This may be the typical situation within your database environment where the you might have killed a SPID (Process) that has been running for long time, without knowing the ROLLBACK operations for such processes. Say if you are executing a stored procedure...
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Tue, May 6 2008
Filed under: Filed under: sql server, transaction log, spid, transactions, processes, sysprocesses, kill, rollback, kpid, sp_who2