marzo 04, 2009
Query Triggers asociados a que Tabla SQL Server
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'
Un sitio de referencias y casos en el desarrollo de sistemas computacionales.
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'