TRIGGER on DATABASE after insert SQL Server

Question

I need to create a trigger on SQL database DB1 that fires when one or more row has been inserted in table T1.

The problem is that the table where i need the trigger could be drop and re-created in a second time, so, if i write the trigger on table T1 this would be dropped too.

what's the way to do that?

Then you need to manually recreate the trigger too. Thats the way to do it — juergen d
– juergen d, Commented Sep 21, 2017 at 11:01
A trigger is part of a table. Drop the table and the trigger is gone. — juergen d
– juergen d, Commented Sep 21, 2017 at 11:04
Why not TRUNCATE instead of DROP? That will retain the table schema and trigger. — Dan Guzman
– Dan Guzman, Commented Sep 21, 2017 at 11:05

Andrew Myers · Accepted Answer · 2017-09-29 03:00:46Z

2

You could create a DDL trigger that would recreate your trigger on table T1.

Maybe have the DDL trigger fire on create table statement, check if your T1 has been created, and, if so, recreate the trigger.

edited Sep 29, 2017 at 3:00

Andrew Myers

2,7865 gold badges36 silver badges42 bronze badges

answered Sep 21, 2017 at 11:10

Craig Foster

1091 silver badge7 bronze badges

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

Collectives™ on Stack Overflow

TRIGGER on DATABASE after insert SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related