Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Transaction??

Status
Not open for further replies.
kakali

kakali

Programmer
Feb 12, 2002
2
IN
Is there a way to create a transaction which will update two tables lying in two different servers?
 
Sort by date Sort by votes
Well, on SQL Server the Distributed Transaction Coordinator (DTC) will handle this for you.

Don't now how other DBMS handle it though.

--James
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

cristianivanoff
  • Locked
  • Question
Calculating amount from transactions...
Replies
1
Views
191
fredericofonseca
fredericofonseca
soushi01
  • Locked
  • Question
Retrieve transaction report 2
Replies
3
Views
92
JarlH
JarlH
pmaths
  • Locked
  • Question
SQL Transaction Log Files not being deleted.
Replies
2
Views
59
pmaths
pmaths
Woodbadge
  • Locked
  • Question
MAX Transaction for each Individual 1
Replies
4
Views
61
rac2
rac2
DJDaveMark
  • Locked
  • Question
Generalise a mySQL query using a Transaction & variables
Replies
1
Views
62
LKBrwnDBA
LKBrwnDBA

Part and Inventory Search

Sponsor

Back
Top