Home Forums SQL Server 2005 Administering Killed Process still rolling back RE: Killed Process still rolling back
Adiga
One Orange Chip
Points: 27284
More actions
March 17, 2009 at 2:33 am
#960862
Sometimes it takes that much time, depending on what it was doing before kill.
DBCC INPUTBUFFER(SPID) would tell you the current status.
Pradeep Adiga Blog: sqldbadiaries.comTwitter: @pradeepadiga