General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
How to connect to another SQL server
I wish to merge data of 2 same tables but located in
different SQL server within the same LAN.
Is there a way to call these 2 tables at the same time
in SQL Analyzer ? such as:
Select * From \\SQL1\table1 Union All Select * from \\SQL2\table2
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only