Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
prevent trigger fire if caused by cascading
Hello, Thankyou for that suggestion. It looked promising in that I thought I could flag a value when the trigger on the parent table fired, and check it on the child table trigger, however it turns out that the child table triggers (update, delete) get triggered first! Therefore I still can't...- Warwick32
- Post #3
- Forum: Microsoft SQL Server: Programming
-
prevent trigger fire if caused by cascading
I've been reviewing a lot of data auding options, and it seems that generic auditing triggers are mostly horrendous to read/understand/maintain and/or have performance problems. I've nearly finished developing a generic stored proceedure that can add a table specific trigger to each table...- Warwick32
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
