SQLTeam.com | Weblogs | Forums

One trigger for insert update delete for all the tables in a database


I need help in creating one trigger for all the dml operation thoroughout all the tables from all database and once any dml operation occur,kill that triggering events.Thanks in advance


Why not just make the database read-only then?


trying to track all the unchanged tables


You'll need to create a trigger on each of the tables. You can't just have one. Sounds like you should be looking into change tracking: https://msdn.microsoft.com/en-us/library/bb933874.aspx