在本机通过SQL远程操作数据库

/*
在本机通过SQL远程操作数据库@@@@@@@@@@@@@@@@@@@@@@@@@@
*/

declare @ServerName sysname
declare @UserName sysname
declare @Password sysname

--初始化连接信息
set @ServerName='192.168.223.90\sql2008'
set @UserName='sa'
set @Password='Wj1234567892'

--打开连接
IF not EXISTS (select srvid from master.dbo.sysservers where srvname = @ServerName )
EXEC sp_addlinkedserver @ServerName

EXEC sp_addlinkedsrvlogin @ServerName ,'false', null, @UserName, @Password

--SQL操作
--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 ')

--关闭连接
EXEC sp_droplinkedsrvlogin @ServerName,@UserName
EXEC sp_droplinkedsrvlogin @ServerName,null
EXEC sp_dropserver @ServerName