Trigger Status Information

Trigger_Status.sql

SELECT 
	 sch.name AS table_schema 
	,tbl.name AS table_name 
	,trig.name AS trigger_name 
	,trig.is_disabled 
	,CASE WHEN is_disabled = 0 THEN 'Enabled' ELSE 'Disabled' END trigger_Status 
FROM sys.triggers AS trig 
LEFT JOIN sys.tables AS tbl ON tbl.object_id = trig.parent_id 
LEFT JOIN sys.schemas AS sch ON sch.schema_id = tbl.schema_id 
WHERE (1=1) 
-- AND trig.name IN( 'TG_T_VWS_SVGElement_Update', 'TR_VWS_SVGElement_SVE_dateDeleted' )