Create Trigger At Database Level


Create Trigger At Database Level


I am faced with this difficulty.

At the start of the month, the client requested me to make a trigger that will fire (an email or insert a row in a table for logging) when ever a "non ETL User" will execute any DML (Insert, Update, Delete) statement on any one of the production databases.

What I want to know is that "Can a trigger be implemented at a database level? Or is it just limited to being implemented on the table level?"

If it can be done, SQL statements on how to actually do this would be much appreciated.

If this is not possible (triggers being implemented at the database level), is there any workaround I can suggest him?