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).