December 9, 2003 at 12:36 pm
I have one application in which I need data from 2 different servers. I currently use a query with OPENROWSET to get what I need and it works fine. If I find more needs to get data across 2 servers, should I use linked servers ? Are there any downsides to Linked Servers ........ pros and cons ?
December 9, 2003 at 12:40 pm
If you are going to query the remote server frecuently then I suggest to set up a linked server.
You must check the security and the queries are going to be easily to write.
December 10, 2003 at 4:50 am
What's the differece between openrowset and using linked servers?
Thanks
December 10, 2003 at 9:27 am
One advantage to setting up a linked server is that the connection and authentication information already exists when making the query, so the call is much simpler. Also one thing to keep in mind when using linked servers. It is always more efficient to write a stored procedure (if possible) on the linked server and call it from the remote one to get data across. For instance, it's better to write "EXEC MyLinkedServer.TheDatabase.dbo.GetRecords @Parameter" than "Select MyRecords FROM MyLinkedServer.TheDatabase.dbo.TheTable Where TheRecord=@Parameter"
Good luck!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply