December 30, 2008 at 1:18 pm
When would you want to set up a linked server in SQL server? Under what circumstance would you want to do this? What iis the benefit of doing this? What is the syntax?
December 30, 2008 at 1:26 pm
Some great information on this can be found at this link
December 30, 2008 at 1:42 pm
This is also a good link from this site right here:
http://www.sqlservercentral.com/articles/Distributed+Queries/anintroductiontolinkedservers/1366
We use linked servers to gather data from some of our smaller SQL databases into a "Data Warehouse" where one can use Crystal Reports or some other tool to query one data bases instead of linking to multiple. So we have our data warehouse sql server that is setup with multiple linked servers to pull all the data necessary for the reports that are needed/requested.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply