Home Forums SQL Server 2005 T-SQL (SS2K5) How many triggers can be implemented in a single table RE: How many triggers can be implemented in a single table

  • September 30, 2009 at 9:27 am

    #1060026

    TRIGGERS ARE EVIL!

    But yeah, I agree with Ian, consolidate triggers wherever possible. Although you can set the trigger order, any time you modify/insert/delete a trigger, that order gets changed and you have to set it again. (At least it does in 2000, not sure if that is different in 2005).

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]