How do I create and query linked database servers in SQL Server?

by

The solution I found:

1) Run a stored proc

exec sp_addlinkedserver    @server="10.0.0.51"

2) Verify that the servers were linked (lists linked servers)

exec sp_linkedservers

3) Run the query using the format

 [10.0.0.51].DatabaseName.dbo.TableName

More Related Contents:

  1. Is it possible to use greater than equal to operator in group by? [closed]
  2. How can I schedule a job to run a SQL query daily?
  3. What’s the best practice for primary keys in tables? [closed]
  4. Reset identity seed after deleting records in SQL Server
  5. Querying data by joining two tables in two database on different servers
  6. Generate a resultset of incrementing dates in TSQL
  7. What is best tool to compare two SQL Server databases (schema and data)? [duplicate]
  8. T-SQL Cast versus Convert
  9. What is the difference between using a cross join and putting a comma between the two tables?
  10. Pivot Table and Concatenate Columns
  11. How would you implement sequences in Microsoft SQL Server?
  12. SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints
  13. What does =* mean?
  14. Correct use of transactions in SQL Server
  15. How can I do a BEFORE UPDATED trigger with sql server?
  16. Favourite performance tuning tricks [closed]
  17. The backend version is not supported to design database diagrams or tables
  18. Deferrable Constraints in SQL Server
  19. How to check which locks are held on a table
  20. How to sum up time field in SQL Server
  21. The object ‘DF__*’ is dependent on column ‘*’ – Changing int to double
  22. Using SQL Server as a DB queue with multiple clients
  23. Suggestions for implementing audit tables in SQL Server?
  24. What does ON [PRIMARY] mean?
  25. How do I list all the columns in a table?
  26. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  27. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  28. Functions vs Stored Procedures
  29. Executing SQL query on multiple databases
  30. Single or multiple databases

Leave a Comment