Retrieving and adding data to tables on different SQL Servers
Is it possible to retrieve data from two tables, located in two different SQL Servers in one domain, and then add the data and save the result in another table in a third SQL Server?
Software/Hardware used:
Software/Hardware used:
ASKED:
April 20, 2009 2:44 PM
UPDATED:
April 20, 2009 3:25 PM
RELATED QUESTIONS
- how can i retrieve the data from sql-server2005 from multiple tables in two combo-boxes in vb6.0 using programming code
- Retrieving data from two tables in SQL Server 2005 Expree Edition using C#
- Store and retrieve data from SQL Server 2005 in UTF-8
- Retrieve data from Oracle9i to SQL server
- How to concat SQL Server 2005 data with line feed
Answer Wiki:
It should be possible if you configure the appropriate <a href="http://msdn.microsoft.com/en-us/library/ms188279.aspx">Linked Servers</a>.
"When you execute a distributed query against a linked server, include a fully qualified, four-part table name for each data source to query. This four-part name should be in the form linked_server_name.catalog.schema.object_name."
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
