DML Trigger on Database not on table

**ck9663** · Mar 12 '15, 04:10 PM

Depending on the version of SQL Server you are using, you may want to look at DDL trigger.

Good luck

~~ CK

**Sowjanya D** · Mar 13 '15, 05:25 AM

Yes I got the DDL trigger for whole Database but I am not getting the DML trigger for Database, DML triggers are only applicable for Tables, How can I do that to solve my problem.

**ck9663** · Mar 13 '15, 04:07 PM

I'm not sure what you are asking. Data Modification Language (DML) are done in a table. If you want to know which table was updated, you might need to set that up every table. Or checkout Change Data Capture and find out which got updated.

Good Luck!!!

~~ CK

**Sowjanya D** · Mar 14 '15, 05:56 AM

for DML we need to write trigger for each table but for my DB there are more number of tables so it is complicated to create each trigger for each table.
I think CDC can be applicable only on user database not on system database.so can you elaborate the working procedure of CDC.

**ck9663** · Mar 16 '15, 04:09 PM

System tables should not be modified like that. You should handle that on user-rights setting. For Data Modification Languages, your only option is trigger or CDC (check BOL). For DDL Languages, you can use database triggers.

Good Luck!!!

~~ CK

DML Trigger on Database not on table

DML Trigger on Database not on table

Comment

Comment

Comment

Comment

Comment