Post reply

Recursive Trigger

  • October 14, 2008 at 12:24 am

    #72078

    I have number of Triggers on My Database but I want to make one of the Trigger as Recursive.Is it Possible?

  • October 14, 2008 at 1:48 am

    #884446

    It's possible, it's not usually a good idea. There is a max permissible recursion level of 32. If you go past that, the trigger will fail and the whole lot will roll back.

    Also you have to enable recursive triggers. It's a database setting, you should be able to change it via Enterprise manager.

    what are you trying to do that you need recursive triggers?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 15, 2008 at 12:23 am

    #885031

    I want recursive triggers ON only for one of the triggers.I want for all other Triggers recursive triggers OFF .Is it possible?

  • October 15, 2008 at 1:08 am

    #885045

    No. Recursive triggers are a database-level setting.

    What are you trying to do that requires recursive triggers?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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