Post reply

Problem with SET XACT_ABORT

  • June 9, 2004 at 1:18 am

    #111552

    How to set XACT_ABORT ON in default rather than specifying in every sp.

    I want the solution for this is because i have created the SP's without specifying the SET XACT_ABORT ON. now how to specify this without altering the SP's

    Its very urgent. Help Me

  • June 9, 2004 at 2:44 am

    #509598

    If you must guarantee that the proc uses XACT_ABORT ON setting, then you have no other choice than to add this to the procedure code and recompile, or make sure that all connections executing these procs will always SET XACT_ABORT ON before executing any of these procs.

    If this should fail, you have no control over which setting any given connection will use.

    SET XACT_ABORT ON|OFF is specific to each connection, and parsed at runtime.

    Therefore, in order to have any control over this, it must be in the procedure code itself. (ie recompile is necessary)

    /Kenneth

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

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