How to find all trigger name in SQL Server

Run the follow Select query to find all triggers in SqlServer and get result.

SELECT T2.[name] TableName, T1.[name] TriggerName,
CASE
WHEN T2.deltrig = T1.id THEN 'Delete'
WHEN T2.instrig = T1.id THEN 'Insert'
WHEN T2.updtrig = T1.id THEN 'Update'
END 'TriggerType'
FROM sysobjects T1 JOIN sysobjects T2
ON T1.parent_obj = T2.[id]
WHERE T1.xtype='TR'
GO