Hi,

I am using Win2K. MSDTC is on on both the servers

Hi,

Thanks for the reply.

I am adding a linked server using the following commands:

sp_addlinkedserver sSourceDBServer ,N'SQL Server'"

sp_addlinkedsrvlogin SourceDBServer,'false', NULL, SourceUserName,SourcePwd

The remote(linked) server is on the same network, but a different...