Post reply

Can we rollback all DML,DDL and DCL commands

  • October 31, 2010 at 9:33 am

    #149173

    Hi,

    Can we rollback all DML,DDL and DCL commands.

    Or is it that we can rollback or commit only particular commands.

    Regards

    cmrhema

  • October 31, 2010 at 10:15 am

    #1244636

    I think that in this type of question it is better to test it for yourself. It will be much faster then waiting for an answer, and there is also a chance that an answer won’t be correct. Here is the pseudo code for a test

    Create table…

    Begin tran

    Alter table XX add column…

    Grant select…

    Insert into..

    Rollback tran

    Check if the modifications were rolled back.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply