anthony.green (1/9/2013)
Yep that is correct.ROLLBACK IMMEDIATE, will force any connections in that databases to stop executing and rollback what they where doing if they where in the middle of a transaction
SINGLE_USER does just what it says, after rollback, change DB to single user so that only 1 SPID can connect to it
That's Awesome
Thanks
so Now the process will finish in only one step, I don't need to do in step-1 and step-2 for kill all connections and set database to single user mode.