SELECT spid, hostname, program_name,  hostprocess, nt_domain, nt_username, net_address, loginame FROM master.dbo.sysprocesses where spid=@@SPID

-- select * from sys.servers

set nocount on
go

create database a1
go

alter database a1 set recovery simple
go

use a1
go

-- основная табличка
create table dbo.t1 ( id int primary key , flag int not null )
go

-- протокольчики
create table dbo.logs ( id int identity primary key , txt varchar(20) not null )
go

-- проца для записи протокольчиков
create proc dbo.p_writelog @txt varchar(20) as set nocount on insert into dbo.logs( txt ) values( @txt )
go

create trigger dbo.t_t1_1 on dbo.t1 for insert as set nocount on
if exists( select 1 from inserted where flag between 1 and 100 ) begin
exec R2.a1.dbo.p_writelog 'wrong flag!'
rollback tran
return
end
go

-- эта должна пройти
insert into t1 ( id , flag ) select 0 , 0
go

-- эта должна зафейлить
insert into t1 ( id , flag ) select 1 , 1
go

select * from dbo.t1
go

select * from dbo.logs
go

use master
go

drop database a1
go