Helping ordinary people create extraordinary websites!

Stored Procedures are EVIL

By Tony Marston
2006-09-07

Database triggers are hidden from the application
A big problem with database triggers is that the application does not know that they exist, therefore does not know whether they have run or not. This became a serious issue in one application (not written by me) which I was maintaining. A new DBA who was not aware of the existence of all these triggers did something which deactivated every trigger on the main database. The triggers were still there, they had not been deleted, but they had been turned off so did not fire and do what they were supposed to do. This mistake took several hours to spot and several days to fix.



Tutorial pages:
 4 Votes

You might also want to check these out:


Leave a Comment on "Stored Procedures are EVIL"
You must be logged in to post a comment.

Link to This Tutorial Page!


GET OUR NEWSLETTERS