That had been verified. The rollback was not going anywhere for hours. Some contractor issued "DROP ASSEMBLY [SqlClassLibrary]".... Instead waiting for hours, we have to get it back even from recovery because it was affecting the entire DEV/QA server and all people. The suspect mode was before restart, not after restart, if you call 4194328 suspect. The key is that particular status code 4194304 = autoshrink 16 = torn page detection 8 = trunc. log on chkpt
AS I mentioned, none of those textbook commands work at the time,
cannot set emergency mode
DBCC checkdb does not return
cannot set single_user or multi_user
You may not have seen this until you see one.
What I have not told you is someone turned on "autoshrink" on this dev host (too many monkeys in the kitchen), that background process cannot be killed. The drop command probably came from a untested script that developer did not know what that portion does.