Cacher is the code snippet organizer for pro developers

SELECT	SysObjects.name AS 'TriggerName', 
		USER_NAME(SysObjects.uid) AS 'TriggerOwner', 
		s.Name AS 'TableSchema', 
		OBJECT_NAME(parent_obj) AS 'TableName', 
		OBJECTPROPERTY(id, 'ExecIsUpdateTrigger') AS 'IsUpdate', 
		OBJECTPROPERTY(id, 'ExecIsDeleteTrigger') AS 'IsDelete', 
		OBJECTPROPERTY(id, 'ExecIsInsertTrigger') AS 'IsInsert', 
		OBJECTPROPERTY(id, 'ExecIsAfterTrigger') AS 'IsAfter', 
		OBJECTPROPERTY(id, 'ExecIsInsteadOfTrigger') AS 'IsInsteadOf',
		OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') AS 'CurrentlyDisabled' 
FROM	SysObjects
		INNER JOIN SysUsers ON SysObjects.uid = SysUsers.uid 
		INNER JOIN sys.Tables t ON SysObjects.parent_obj = t.object_id 
		INNER JOIN sys.Schemas s ON t.schema_id = s.schema_id 
WHERE SysObjects.type = 'TR'