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

  • I see triggers as a mixed bag. I use them but only when I think they are the most elegant way of handling a problem. I think that the

    triggers are bad - because ... they are really hard to managed in big database

    comment was probably referring to the fact that if you are not used to looking for them/using them, they can be forgotten and you can easily have logic occurring that seems to be outside what someone would look for. In a small database where you can be intimately familiar with all the tables it's easier to remember that they are there and operating. In a database with hundreds of tables and only a hand full of triggers, well... Things can be forgotten easier. Just a guess as to what the poster was thinking though.