Mssql uses the linked server when querying multiple databases. The following describes how to add the linked server. After adding the link server, you can query multiple databases on any server.
Mssql uses the linked server when querying multiple databases. The following describes how to add the linked server. After adding the link server, you can query multiple databases on any server.
Exec sp_droplinkedsrvlogin ZYB, Null -- delete ing (ing between recording and remote logon on the linked server)
Exec sp_dropserver ZYB -- delete the remote server Link
EXEC sp_addmediaserver
@ Server = 'zyb', -- the alias of the accessed server
@ Srvproduct = '',
@ Provider = 'sqloledb ',
@ Datasrc = "/Server2" -- the server to be accessed
EXEC sp_add1_srvlogin
'Zyb', -- the alias of the accessed Server
'False ',
NULL,
'Sa ', -- account
'Sa '-- Password
Instance used:
Select * from ZYB. CDCenter20110822.dbo. cardbase
