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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linked Servers??

Status
Not open for further replies.
aljubicic

aljubicic

Programmer
Nov 7, 2002
82
AU
Hi All,

If I had two servers - one Server A and the other Server B.

Server A has Server B as a linked Server and Server B has Server A as a linked Server.

Could someone tell me whether this is viable? Whether it is permitted to have servers Linked and back the other way as well or does this cause problems??

As What I am trying to achieve is to pass data through triggers from one database to the other and vice-versa.

If I am unable to achieve this without problems, what would be the best way around this?

Thanks
Anthony
 
Status
Not open for further replies.

Similar threads

GripS321
  • Locked
  • Question
Trouble adding chunk to linked location
Replies
8
Views
126
GripS321
GripS321
robert030975
  • Locked
  • Question
updating a linked Informix server in 2005 64bit
Replies
0
Views
56
robert030975
robert030975
buddafish
  • Locked
  • Question
Linked Server SQL2005 Select
Replies
0
Views
48
buddafish
buddafish
craig322
  • Locked
  • Question
Multiple database servers on single physical server
Replies
0
Views
50
craig322
craig322
Iamblue
  • Locked
  • Question
Insert/update on Informix db through linked server
Replies
5
Views
125
Iamblue
Iamblue

Part and Inventory Search

Sponsor

Back
Top