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
– marc_s, Commented Dec 14, 2014 at 19:30

Community · Accepted Answer · 2017-05-23 10:33:38Z

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, 2017 at 10:33

CommunityBot

11 silver badge

answered Dec 14, 2014 at 19:52

Neil N

25.3k17 gold badges87 silver badges148 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

programmer Over a year ago

Can I override OnSaveChanges Event?

Neil N Over a year ago

Technically, you would want to override SaveChanges method of your implementation of ObjectContext. That is, if you are using entity framework.

Collectives™ on Stack Overflow

How to Create a single Trigger on multiple Database Tables

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related