SQLTeam.com | Weblogs | Forums

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


#1

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


#2

Why not just make the database read-only then?


#3

trying to track all the unchanged tables


#4

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