Browse by Tags

All Tags » tsql » trigger » tables (RSS)
TSQL to find all triggers in a database including their count
Published 23 August 7 3:28 AM | SSQA.net
For SQL Server 2000 version: SELECT S2.[name] TableName, S1.[name] TriggerName, CASE WHEN S2.deltrig = s1.id THEN 'Delete' WHEN S2.instrig = s1.id THEN 'Insert' WHEN S2.updtrig = s1.id THEN 'Update' END 'TriggerType' ,...
Filed under: , , , ,