select [name] from sys.triggers where [object_id] = object_id('имя_вашей_таблицы]');

select
      object_name([referencing_id]) as [trigger_name],
      object_name(t.[parent_id]) as [source_table_name]
from sys.triggers t
    join sys.sql_expression_dependencies ed on ed.[referencing_id] = t.[object_id]
where [referenced_entity_name] = 'T2'
  and [referenced_class] = 1;

create table T1 (id int);
create table T2 (id int);

create or alter trigger TR1 on T1 for insert
as
exec ('insert into T2 values(1)');

select [name] from sys.objects where [type] = 'TR' and charindex('T2', object_definition([object_id])) > 0;