Transactions between multple servers.

  • Thread starter Thread starter Luis Esteban Valencia
  • Start date Start date
L

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.
 
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
 
Back
Top