kill & rollback

what if you wanted to kill the rollback?
can it be done?You can shutdown the SQL Server service. Normally, the rollback would resume
when the service is started again, but you can re-start the service using a
special command line parameter that indicates not to resume rollbacks.
However, the database will probably be left marked as suspect. At that
point, you may choose to restore the database from a recent backup that took
place before the transaction started.
I think the parameter is -T4022, but you will need to research this further
on MSDN.COM
"marcmc" <marcmc@.discussions.microsoft.com> wrote in message
news:EFBEBFAA-F4B2-4633-A8AA-BC3E1BF7A94A@.microsoft.com...
> what if you wanted to kill the rollback?
> can it be done?|||No. Once you have killed a process and it is being rolled back, you can't
resurrect it again, and you have to wait until the rollback has been
completed.
Jacco Schalkwijk
SQL Server MVP
"marcmc" <marcmc@.discussions.microsoft.com> wrote in message
news:EFBEBFAA-F4B2-4633-A8AA-BC3E1BF7A94A@.microsoft.com...
> what if you wanted to kill the rollback?
> can it be done?