Remote database operations through SQL on the local machine

/*
Remotely operate a database through SQL on the local machine @@@@@@@@@@@@@@@@@@@@@@@@@@
*/

Declare @ servername sysname
Declare @ username sysname
Declare @ password sysname

-- Initialize connection information
Set @ servername = '192. 168.223.90 \ sql2008'
Set @ username = 'sa'
Set @ Password = 'wj1234567892'

-- Open connection
If not exists (select srvid from Master. DBO. sysservers where srvname = @ servername)
Exec sp_addmediaserver @ servername

Exec sp_add1_srvlogin @ servername, 'false', null, @ username, @ Password

-- SQL operation
-- Exec ('select * from ['+ @ servername +']. xlink. adm. message') -- adm. Message

-- Exec ('select * From shipmentmethodfcl_temp ')

-- Exec ('insert into ['+ @ servername +']. xlink. DBO. shipmentmethodfcl_temp select * From shipmentmethodfcl_temp ')

-- Exec ('insert into ['+ @ servername +']. xlink. DBO. shipmentmethodlcl_temp select * From shipmentmethodlcl_temp ')


-- Close connection
Exec sp_droplinkedsrvlogin @ servername, @ username
Exec sp_droplinkedsrvlogin @ servername, null
Exec sp_dropserver @ servername