SQL Server connection query between two servers

-- Query the connection between two servers:
-- Establish a connection:
Sp_addmediaserver HS
Sp_addmediaserver HS1
Exec sp_add1_srvlogin 'hs ', 'false', 'sa', 'sa ', '123'
Exec sp_add1_srvlogin 'hs1 ', 'false', 'sa', 'sa ', '123'

-- HS and HS1 are two machine names.
-- 1234 is the password
-- SA is a user of course.

-- For example, the fullname of the stock of HS5 \ HS6:
Select a. fullname, B. fullname From HS. hs5.dbo. Stock A, hs1.hs6. DBO. Stock B

-- Delete a connection:
Exec sp_droplinkedsrvlogin 'hs ', 'false', 'sa', 'sa ', '123'
Exec sp_droplinkedsrvlogin 'hs1 ', 'false', 'sa', 'sa ', '123'
Sp_dropserver HS
Sp_dropserver HS1