Hi,
After following the Books Online instructions to setup a remote procedure
call:
"How to set up a remote server to allow the use of remote stored procedures
(Transact-SQL)"
The 2 boxes are in same WORKGROUP and sa passwords are the same.

I can execute SQLServer2.SP1 from SQLServer1 no problems and returns rows.
ie  exec [SQLServer2].[db].dbo.SP1

As soon as I try to do this:-
  insert #tmptable(field1,field2....)
    exec [SQLServer2].[db].dbo.SP1

.... I get "MSDTC on server 'SQLServer2' is unavailable." everytime.

It must be having some sort of trouble with the implicit transaction part of
this statement BUT dont know how to fix it.

Can someone please help, I've tried everything

The first thing to check would be whether the DTC service is up and running.

You can do it via the SQL Server Service Manager.


ML

ahh, sorry. and YES, MSDTC service is up and running

Show quoteHide quote

convert INT
A difficult Combining Rows problem
How to use OPENXML to retrieve detail lineitems
Rearrange column
SQL view deducting multiples