TSQL to find all triggers in a database including their count

Published 23 August 07 01:28 AM | SQL Master  
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' , 'S1',s1.*,'S2',s2.*
FROM sysobjects S1 JOIN sysobjects S2 ON S1.parent_obj = S2.[id] WHERE S1.xtype='TR'
For SQL Server 2005 version: 
SELECT count(*) FROM sys.triggers
go
SELECT count(*) FROM sys.server_triggers

Comments

# SSQA.net - SqlServer-QA.net said on August 23, 2007 3:09 AM:

For SQL Server 2000 version: SELECT S2.[name] TableName, S1.[name] TriggerName, CASE WHEN S2.deltrig

# Other SQL Server Blogs around the Web said on August 23, 2007 3:35 AM:

For SQL Server 2000 version: SELECT S2.[name] TableName, S1.[name] TriggerName, CASE WHEN S2.deltrig

Anonymous comments are disabled

About SQL Master

**__________________________________** SQL Server MVP, Sr. DBA & industry expert. - Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.