As a DBA the only option you have available to you is to Kill the particular SPID using the Kill command. However this does not mean an instant rollback. The rollback process will be dependant on the activity the transaction was performing and how large
a rollback is required. This could infact take quite a long time to complete. You want to understand the process that you are wanting to kill.
I hope this helps.
Warwick Rudd
MCT MCITP SQL Server 2008 Admin
My Blog
-------------------------------------------------------
Please mark as Answered if I have answered your question
Please vote if this was useful
-------------------------------------------------------
Movember is here. Show your support for Mens Health
by making a donation here -
Movember