I have been recently helping my fried on very large database ,which has hundred od tables to determine which table has a trigger. So I came out with the below script that may help others to identify triggers define on the tables.
--SQL Server 2000(SP3)
, CASE WHEN instrig <> 0 then OBJECT_NAME (instrig) ELSE 'None' END as
, CASE WHEN updtrig <> 0 then OBJECT_NAME (updtrig) ELSE 'None' END as
, CASE WHEN deltrig <> 0 then OBJECT_NAME (deltrig) ELSE 'None' END as
type = 'U'
( instrig <> 0
updtrig <> 0
deltrig <> 0