PCB SQL Server 代碼建立DbLink

標籤：log   pass   rod   資料   self   user   elf   exe   rop   

 

代碼如下：

DECLARE @serverName VARCHAR(100)DECLARE @ip VARCHAR(100)DECLARE @dbName VARCHAR(100)DECLARE @userName VARCHAR(100)DECLARE @userpassword VARCHAR(100)SET @serverName = ‘DbLinkName‘   --db連結名SET @ip = ‘120.79.36.65‘         --需串連伺服器的IPSET @dbName = ‘DbName‘           --需串連伺服器的資料庫名SET @userName = ‘sxi‘            --需串連伺服器的帳號 SET @userpassword = ‘***‘        --需串連伺服器的密碼EXEC master.dbo.sp_addlinkedserver @server = @serverName, @srvproduct=@serverName, @provider=N‘SQLNCLI‘, @datasrc=@ip, @catalog=@dbNameEXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=@serverName,@useself=N‘False‘,@locallogin=NULL,@rmtuser=@userName,@rmtpassword=@userpasswordEXEC master.dbo.sp_serveroption @server=@serverName, @optname=N‘rpc‘, @optvalue=N‘true‘EXEC master.dbo.sp_serveroption @server=@serverName, @optname=N‘rpc out‘, @optvalue=N‘true‘

 

PCB SQL Server 代碼建立DbLink