Multi table Triggers SQL Server noob

Question

I have a load of tables all with the same 2 datetime columns (lastModDate, dateAdded). I am wondering if I can set up global Insert Update trigger for these tables to set the datetime values. Or if not, what approaches are there?

Any pointers much appreciated

Answer 1

I agree there is no such Global Trigger, but we can certainly reduce our efforts by creating script which will generate triggers for the tables.

Something like: http://weblogs.sqlteam.com/brettk/archive/2006/11/29/35816.aspx

Answer 2

No, there's no such thing as a "global" trigger or a multi-table triggers. Triggers are by design bound to a table, so if you need to have triggers on a load of tables, you need to create a load of triggers, one for each table, and deploy them. No way around that, I'm afraid.