@@trigger_name Global Variable

The @@trigger_name global variable returns the name of the trigger that is currently executing..

You can place the following in the body of a trigger or in the body of a stored procedure that is called (at any level of nesting) from a trigger:

select @@trigger_name

If nested triggers are fired, @@trigger_name holds the name of the most recently fired trigger.