Post reply

Error while executing trigger.

  • August 18, 2005 at 7:05 am

    #582992

    Can you post the trigger code?

    Looks like you are deleting rows from the same table in the said trigger and that it is being refired everytime.

  • August 18, 2005 at 12:46 pm

    #583252

    if you have the nested triggers flag enabled make sure it is really needed otherwise turn it off

    If you are calling a recursive stored procedure or a recursive function in the trigger code make sure that in their code you check @@nestedlevel vairable and that call stack is not deeper than 32!

     

     


    * Noel

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

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