隨便寫寫的新天地

DECLARE @SrvName varchar(100)
DECLARE @UsrName varchar(100)
DECLARE @UsrPwd varchar(100)

SET @SrvName = 'aaa'
SET @UsrName = 'sa'
SET @UsrPwd = ''

-- 建立連結
IF (SELECT COUNT(*) FROM master.dbo.sysservers WHERE srvname = @SrvName) < 1  BEGIN
 EXEC sp_addlinkedserver @SrvName
 EXEC sp_addlinkedsrvlogin @SrvName , 'false' , null , @UsrName , @UsrPwd
END

-- 刪除連結
IF (SELECT COUNT(*) FROM master.dbo.sysservers WHERE srvname = @SrvName) = 1  BEGIN
 EXEC sp_droplinkedsrvlogin @SrvName, null
 EXEC sp_dropserver @SrvName
END