Selecting data from two different servers in SQL Server

by

What you are looking for are Linked Servers. You can get to them in SSMS from the following location in the tree of the Object Explorer:

Server Objects-->Linked Servers

or you can use sp_addlinkedserver.

You only have to set up one. Once you have that, you can call a table on the other server like so:

select
    *
from
    LocalTable,
    [OtherServerName].[OtherDB].[dbo].[OtherTable]

Note that the owner isn’t always dbo, so make sure to replace it with whatever schema you use.

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. How do I UPDATE from a SELECT in SQL Server?
  3. Get top 1 row of each group
  4. How to return only the Date from a SQL Server DateTime datatype
  5. How to calculate age (in years) based on Date of Birth and getDate()
  6. CROSS JOIN vs INNER JOIN in SQL
  7. Referring to a Column Alias in a WHERE Clause
  8. T-SQL dynamic pivot
  9. Avoid duplicates in INSERT INTO SELECT query in SQL Server
  10. How do you list the primary key of a SQL Server table?
  11. Select group of rows that match all items in a list
  12. Calculating distance between two points (Latitude, Longitude)
  13. Add Foreign Key relationship between two Databases
  14. SQL Server check case-sensitivity?
  15. How to update Identity Column in SQL Server?
  16. Concatenate values based on ID
  17. Why and when a LEFT JOIN with condition in WHERE clause is not equivalent to the same LEFT JOIN in ON? [duplicate]
  18. varbinary to string on SQL Server
  19. Scope of temporary tables in SQL Server
  20. SQL Server 2005 ROW_NUMBER() without ORDER BY
  21. Can an INNER JOIN offer better performance than EXISTS
  22. Find the real column name of an alias used in a view?
  23. How to get the identity of an inserted row?
  24. How to create a pivot query in sql server without aggregate function
  25. TSQL – How to use GO inside of a BEGIN .. END block?
  26. SQL Server FOR XML Path make repeating nodes
  27. SQL – How do I get only the numbers after the decimal?
  28. How to retrieve records for last 30 minutes in MS SQL?
  29. Group consecutive rows of same value using time spans
  30. Why do SQL Server Scalar-valued functions get slower?

Leave a Comment