exec  sp_addserver  rpc_srv_name, RPCServer, your_srv_name
go
-- test
exec rpc_srv_name...sp_who
go

use test_db
go

create table test_work(col1 int, col2 int)
go
create table test_log(col1 int, col2 int)
go

create proc test_autonom
as
begin 
begin transaction
insert into test_log values(1,2)
commit transaction
end

create proc test_work_proc
as
begin
begin transaction
insert into test_work values(10,20)
declare @status int
exec @status = rpc_VRC.SYBACKUP..test_autonom
rollback transaction
end

exec test_work_proc
go

select * from test_work
select * from test_log
go
drop proc test_work_proc
drop proc test_autonom
drop table test_work
drop table test_log
go