This month’s T-SQL Tuesday is brought by Steve Jones (b | t) and he wants to know if triggers causes headaches or happiness to us.
This is the 106nd edition of TSQL2sDay - an Adam Machanic (b | t) brainchild.
Triggers are those kind of database objects that sometimes are the best bet but most of the times they will strike back.
“Why?” - You may ask. From my experience triggers are objects that we “tend” to forget are there, and only when we hit a problem and, sometimes, after digging into the problem we end by saying something like
