Re: Problem with transactions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

It says raiseerror right in it, that's always going to fail, so what
are you trying to do with this SP? SQL is clearly trying to commit a
transaction that has been aborted, that's why the counts don't match
and it says it right in the error message. It could be because the
SQL Adapter is using it's own transaction and your forced error is
making it have issues. Why are you force raising an error in the
catch? Shouldn't you just return some sort of status and not
basically throw an exception to BizTalk?

-Kind Regards,
-Dan
.

Relevant Pages

  • Re: Locking and Delay in a Bottleneck
    ... that should avoid the gap issue on rollback, ... SQL Server MVP ... the saving transaction, this journal voucher is having a header table ... number in a table whereupon you commit. ...
    (microsoft.public.sqlserver.programming)
  • Re: Trigger does not seem to fire from front end or enterprise manager
    ... there is no need to even do COMMIT in a trigger. ... > the transaction will be committed as the statement completes. ... > against the inserted and deleted tables inside your trigger code. ... run a profiler trace and you will see what SQL EM submits. ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Server Analysis Services Query in a SQL Server job step
    ... My guess is that each request (begin transaction, execute processing, ... Try out the MSDN Forums for Analysis Services at: ... I have a step (SQL Server Analysis Services Query) inside of a 2005 SQL ... begin, commit, rollback transactions all within the code. ...
    (microsoft.public.sqlserver.olap)
  • Re: Behavior of Connection.commit()
    ... Does it say "commit" and "rollback" and other SQL commands that affect the transaction state are not allowed? ... How sure can the driver ever be about the state of the transaction? ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Autonomous Transactions
    ... You mean that I always have to explicitly commit or rollback sql ... You don't have much SQL in your app. ... Now what happens is that at the beginning of each procedure you start a transaction and at the end you either commit or rollback whatever the procedure does. ... The outermost procedure represents the interface to your app and you app does NOT contain any COMMIT/ROLLBACK. ...
    (comp.databases.oracle.server)