• Got it.:)

    Declare @sql nvarchar(MAX)

    Set @sql = ''

    Select @sql = @sql + 'USE ' + name + '

    select '''+name+''' as DBName, p.name as [TableName], o.name, o.deltrig, o.instrig, o.updtrig,

    t.is_disabled

    from sysobjects o

    left outer join sysobjects p ON p.id = o.parent_obj

    inner join sys.triggers t on t.object_id = o.id

    where o.type=''TR''

    '

    from master..sysdatabases

    Where DBID > 4 --skip the system databases

    EXEC (@sql)