I'd use the XTYPE column in the SYSOBJECTS table, in each database. Like this
master..sp_msforeachdb [select '?', count(*) from ?..sysobjects where xtype = 'TR']
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples