Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Location
    NJ
    Posts
    139

    Unanswered: mutating trigger

    Hi,
    Can anyone tell me what mutating triggers are and where I can find a definition?

    thanks
    Alex

  2. #2
    Join Date
    Jan 2003
    Posts
    14

    Re: mutating trigger

    A mutating trigger occurs when the table that originally fired the triggering event is being accessed in the body of the trigger code, directly or implicitly in a procedure, or in a nested trigger called from the trigger body.

    This action is forbidden in most databases because the table is in middle of a transaction, and referencing the same table again in the middle of the updating action causes the trigger to mutate.
    M2001

Posting Permissions

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