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?
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