Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    16

    Unanswered: How to commit a transaction even when trigger fails

    I have a row that, when updated, triggers a stored procedure. However, if this stored procedure fails, the row is never updated at all.

    I know with SQL 2000, you can specify on on_event argument of AFTER so that the transaction is actually "committed" before the trigger goes off, but is there a similar way to do this with SQL 7? I can't seem to find a way to have the "trigger" action take effect regardless if whatever action the trigger causes fails or not.

    Ed

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    Could you issue a commit right before calling the sp?
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •