Linked servers are useful in cross-database/cross-server queries (such as in a distributed database system), and this article will detail graphically how to use SQL Server Management Studio to create a linked server under the graphical interface. 1. Expand Server Objects--linked servers--right-click on "New Linked server"
Note: You must be logged on as a database administrator (typically the SA account) before you can create a "linked server"
2. Enter the IP of the linked server
3. Setting the security of a linked server
When completed, such as:
Now test, log in to SQL Server locally with account user, create a new query, and enter SELECT * from [linked server name]. [Remote database name]. [owner]. [Table name]
Like what
Select * FROM [127.0.0.1]. [Cntvs]. [dbo]. [T_class]
If you have any questions, you can get the data.
Creating linked servers in SQL Server