请教如何在存储过程里写添加远程服务器语句

owen_zeng

create proc my
as
begin
EXEC master.dbo.sp_addlinkedserver @server = N'TEST', @srvproduct=N'dsaf', @provider=N'SQLOLEDB', @datasrc=N'192.168.1.204,1433'
/* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'TEST',@useself=N'False',@locallogin=NULL,@rmtuser=N'sa',@rmtpassword='123456'
end
试试这样的