I want a script to create trigger dynamically. I have 100 tables and i need to create insert and delete trigger.
Thanks in advance.
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
What have you tried thus far?
I have written for insert/update trigger. You can check the script attached. I will shortly write for delete. This will be helpful.
21 People are following this question.
,Restore filelist is terminating abnormally
How to display Database when using sp_foreachdb
Two Way Brainstroming Grouping in sql
Looking for a needle in an SQL haystack
Search for a String value in 2 columns of all table in a database