Cacher is the code snippet organizer for pro developers

--Recuerda no estar en master etc
-- ---------------------------------------------------------------------
--1.- Si sabes el PROCID
SELECT
    OBJECT_NAME(parent_id) AS [Table],
    OBJECT_NAME(object_id) AS TriggerName
FROM
    sys.triggers
WHERE
    object_id = @@PROCID
-- ---------------------------------------------------------------------
--2.- Si sabes el nombre del trigger
SELECT o.name
FROM sysobjects t
JOIN sysobjects o ON t.parent_obj = o.id
WHERE t.name = 'nombredeltrigger'
-- ---------------------------------------------------------------------