Post reply

trigger firing order

  • September 14, 2005 at 6:57 am

    #89772

    I know you can set the firing order of triggers with sp_settriggerorder.  But once they have been set, how do you list the firing order?

  • September 14, 2005 at 6:59 am

    #589679

    Check out the objectproperty function and the properties "ExecIsFirst*"

  • September 14, 2005 at 11:23 am

    #589828

    I wouldn't rely much on the order of triggers. Rather have it in one.

    You have first, last, and between (with no order)

  • September 14, 2005 at 11:41 am

    #589838

    Our user update,insert, delete triggers are in one.  But we are using a replication package (Vision Orion/Symbiator) which generates additional triggers and we didn't want the mix our user triggers code with those from the replication package.

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

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