SELECT object_name(id), object_name(deltrig),
object_name(instrig), object_name(updtrig)
FROM sysobjects
WHERE xtype ='U'
AND
(deltrig > 0 OR instrig > 0 OR updtrig > 0)