Home Forums Article Discussions Article Discussions by Author Discuss content posted by bitbucket Transactions 1 RE: Transactions 1

  • May 16, 2012 at 6:36 am

    #1488327

    Thomas Abraham (5/16/2012)

    Hugo Kornelis (5/16/2012)The only way I can reproduce what you are seeing, both on SQL Server 2008 R2 (I don't have 2008 vanilla) and on SQL Server 2012, is by setting the SET XACT_ABORT option to ON. (It is OFF by default).

    Are you running this from a connection where you previously executed a SET XACT_ABORT ON command? Or from a client that implicitly emits this command upon connecting?

    I was using a fresh connect that does not emit this command. Is there a command on the order of sp_configure that I can run to verify?

    According to this article[/url], you can check the current setting of SET XACT_ABORT by running SELECT 16384 & @@OPTIONS; - if the result is 16384, it is on; if it's 0, the option is off.

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/