Unanswered: How to communicate between two different servers from one stored procedures
Iam using Sybase 12.53
There is a stored procedure where for a particular column of the resultset we need to search for some data in one server and if the data is not there in that server we need to look for the data in another server.
Is it possible to communicate between two different servers from one stored procedures? If it is possible can anyone tell me how to do that?
Michael even I am facing the same problem as Sumesh and tried what you explained.
I am facing a problem while creating a proxy table. The remote server what am trying to access is not there in sysservers. Can I add it to the sysservers and if I can could you please explain how to add it?