SQL Server multi-database query sp_addmediaserver usage (add link 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