Microsoft SQL Server 2005 - 9.00.4266.00 (X64) Oct 7 2009 17:38:17

Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

namexx_Test

dbid46

sid0x010500000000000515000000596FB2542C1A072CB776D02C046E0000

mode0

status4194328

status21090519040

crdate2010-09-03 15:24:58.030

reserved1900-01-01 00:00:00.000

category0

cmptlevel90

filenameF:\SQLData\xx_Test.mdf

version611

cannot detach

cannot take offline

cannot change to single user mode

the run-away process is being killed and is showing as rollback but 0% progress by kill SPID command 2nd time.

not sure what status this is: Status = 4194304 + 16 + 8

restart sql server service, it went away.