Transactions between multple servers.

[Luis Esteban Valencia]

I have an applications that makes some UDPATES and INSERTS but those
commands are on differente servers: How can I make them to execute as an
unit ? I mean as a transaction

I tried but an sqltransaction can only be assigned to ONE connection.

 

[Roberto Lopes]

Hi Luis,

Are you using SQL Server 2000? If you do, you can use Linked Servers. If you
are using SyBase, I think the concept is foreign table.
It's just put all in only onetransaction.

Roberto Lopes