How to Create a single Trigger on multiple Database Tables

Question

I have a database which contains some tables such as article, news, projects,...

I want to save a record to another table (Activity) when a record inserted into each table in database without activity

I don't want to create a trigger for each table.

How can I do it?

Triggers **are** table-based - you cannot create "database-wide" triggers ... — marc_s, Dec 14 '14 at 19:30

score 1 · Accepted Answer · edited May 23 '17 at 10:33

1

If you were to use an intermediate layer, such as an ORM like Entity Framework, you could, in effect, have a "database wide" trigger, by overriding the OnSaveChanges event to add a log record anytime something is committed to the database.

My answer on This Question does exactly that

edited May 23 '17 at 10:33

Community

1
1

answered Dec 14 '14 at 19:52

Neil N

24,862
16
85
145

Can I override OnSaveChanges Event? – programmer Dec 14 '14 at 19:58
Technically, you would want to override SaveChanges method of your implementation of ObjectContext. That is, if you are using entity framework. – Neil N Dec 14 '14 at 21:22

How to Create a single Trigger on multiple Database Tables

1 Answers1