April 8, 2005 at 1:35 pm
We are rewriting one of our in-house applications, including database modifications. The current version passes data to another application database residing on the same SQL server using embedded SQL statements.
We are creating a new version of our database to allow us to rollout the new application in stages across the company and our new database will reside on a different server but need to write data to the same secondary application database. I a researching pros and cons of linking the two servers, I have testing in development and it appears to answer all our problems. Both are SQLServer 2000. Any input on this subject will be greatly appreciated.
April 8, 2005 at 3:31 pm
linked servers can be a real Godsend. You should exercise great care in setting up the security between them. I have seen several cases where the linked server login mapping leaves the target server wide open. You should also generally avoid joining large tables across the servers.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 13, 2005 at 2:22 pm
I've been unsuccessful linking servers. Could you give me any guidance ?
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply