Este script genera un reporte de todos los triggers en una base de datos, indicando si estan habilitados o no.
DECLARE @trigger VARCHAR(50)
SET @trigger = ''
declare @sqlstring VARCHAR(200)
SET NOCOUNT ON
create table #triggers
(tablename varchar(50),
triggername varchar(50),
disabled smallint
)
WHILE @trigger IS NOT NULL
BEGIN
SELECT @trigger = MIN( Name )
FROM sysobjects where type = 'TR' and name > @trigger
IF @trigger IS NOT NULL
BEGIN
set @sqlstring = 'select object_name(parent_obj),'''+@trigger+''',OBJECTPROPERTY(object_id('''+@trigger+'''),''ExecIsTriggerDisabled'') from sysobjects where id = object_id('''+@trigger+''')'
insert into #triggers
exec (@sqlstring)
END
END
select * from #triggers
drop table #triggers
SET NOCOUNT OFF