Post reply

INSERT and EXEC creating transaction

  • May 17, 2005 at 10:44 am

    #67697

    When I run an INSERT statement utilizing the execute_statement option to execute a stored procedure the stored procdure appears to be running inside a transaction.  Is there a way to execute this without creating a transaction?

    Thanks

  • May 17, 2005 at 10:49 am

    #559321

    Typically all SQL operations will run in a transactional context. Look at autocommit mode in the BOL index. Check out the subtopic Autocommit Transactions.

    HTH,



    -Brandon

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

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