Return database that a trigger was executed in

[omrsafetyo]

I would like to create a variable in my trigger - @DBNAME.
When the trigger executes, this value should be set to the name of the database it was executed in.

E.g. for the master database the value of @DBNAME would be master.

How would I go about figuring out which database this was executed in? (This same trigger would be in place across multiple databases).

Thanks!

[dickersonka]

select db_name()

[omrsafetyo]

It seems so obvious looking at the function name.

Thanks for your help!