• 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.