Un sitio de referencias y casos en el desarrollo de software.
SELECT po.name as Tabla, tr.name as [Trigger Name]
FROM sysobjects po
JOIN sysobjects tr ON tr.parent_obj = po.id
WHERE tr.xtype = 'TR'AND po.xtype = 'U'