Post reply

SET COMMAND TO ROLLBACK

  • September 14, 2005 at 2:44 pm

    #168356

    What is the set command that rollback entire query batch on error.

    I remember I have used it once.

    Regards,
    gova

  • September 14, 2005 at 2:48 pm

    #589920

    SET XACT_ABORT ON.

    Set it in run time

  • September 14, 2005 at 2:49 pm

    #589921

    SET XACT_ABORT ON

    Dam! got my own medicine (Beat me by a minute )


    * Noel

  • September 15, 2005 at 2:25 am

    #590036

    Thanks peterhe and noeld. It was in my mind and did not come to the key board. For some reason i didn't see that in BOL then.

    Regards,
    gova

  • September 15, 2005 at 6:37 am

    #590094

    Remember that it's a smalldatetime datatype. Maybe it was just by a second but it got rounded up... those damn memory exceptions .

Viewing 5 posts - 1 through 4 (of 4 total)

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