sqlserver分布式存储过程

use GHFN go--声明host(地址)、user(用户)、pwd(密码)declare @host varchar(20);declare @user varchar(20);declare @pwd  varchar(20);--赋值声明host(地址)、user(用户)、pwd(密码)set @host='10.1.1.35';set @user='sa';set @pwd='bdxx';--删除已经存在的ghfn_remost_hostif exists(select 1 from sys.servers where sys.servers.name='ghfn_remost_host')EXEC sp_dropserver    @server='ghfn_remost_host',   @droplogins='droplogins';--创建一个链接服务器EXEC sp_addlinkedserver      @server='ghfn_remost_host',    @srvproduct='',   @provider='SQLOLEDB',    @datasrc=@host;--通过链接服务器登录远程sql服务器EXEC sp_addlinkedsrvlogin   @rmtsrvname='ghfn_remost_host',  @useself='false',  @locallogin=null,  @rmtuser=@user,  @rmtpassword=@pwd;GO--操作远程sql服务器select * from ghfn_remost_host.ghfn.dbo.sys_users;--delete from ghfn_remost_host.ghfn.dbo.sys_users --where sys_users.sys_id='001';--insert into ghfn_remost_host.ghfn.dbo.SYS_USERS--  (SYS_ID,USER_ID,USER_NAME)--values--  ('111','840003','李四')--使用完后删除链接服务器EXEC sp_dropserver    @server='ghfn_remost_host',   @droplogins='droplogins';