create table dbo.t1 (id int)
go

create trigger dbo.t_ins on dbo.t1 
with execute as owner
for insert
as
	select 
		trigger_name = object_schema_name(object_id) + '.' + object_name(object_id)
		, table_name = object_schema_name(parent_object_id) + '.' + object_name(parent_object_id)
	from sys.objects
	where
		object_id = @@PROCID
go 

insert dbo.t1 
select 1


drop table dbo.t1