create table ##triggers (DbName sysname, TriggerName sysname);
insert into ##triggers(DbName, TriggerName)
exec sp_msforeachdb 'use [?]; SELECT  ''?'' as DbName, name FROM sys.triggers WHERE type = ''TR'';';
select * from ##triggers;
drop table ##triggers;