Cross-database access--linked servers

Method One:

1. Create a linked server

Linked server local name--linkserver destination address--192.168.8.11

exec sp_addlinkedserver ' linkserver ', ', ' SQLOLEDB ', ' 192.168.8.11 '

2, log on to the linked server

Linked server local name--linkserver login--sa Password--11111

exec sp_addlinkedsrvlogin ' linkserver ', ' false ', NULL, ' sa ', ' 11111 '

3, Query

SELECT * from Linkserver. database. Table

Method Two: A database server >> server object >> linked server >> Right-click Create linked server >> fill in the linked server,

Server type, product name "can be casually written", data source [IP address], security in the use of this security context to establish a connection "remote server login, password". Then use the method of a query statement can be detected

Cross-database access--linked servers