MSSQLServer cross-server linked server creation methods are as follows
Copy Code code as follows:
--Declaring variables
Declare @svrname varchar (255),
@dbname varchar (255),
@sapassword varchar (255)
--Please modify the following variables according to the actual situation before execution
Select @svrname = ' target server name ',
@dbname = ' target database ',
@sapassword = target Database password
If exists (select Srvname from master.dbo.sysservers where srvname = ' linked server name ')
exec sp_dropserver @server = ' linked server name ', @droplogins = ' droplogins '
--Adding linked servers
exec sp_addlinkedserver @server = ' linked server name ', @srvproduct = ', @provider = ' sqloledb ', @datasrc = @svrname, @catalog = @dbname
--Increase remote logins for linked servers
exec sp_addlinkedsrvlogin @rmtsrvname = ' linked server name ', @useself = ' False ', @locallogin = ' sa ', @rmtuser = ' sa ', @rmtpassword =@ Sapassword
--Configuration parameters
exec sp_serveroption @server = ' linked server name ', @optname = ' Use remote collation ', @optvalue = ' false '
exec sp_serveroption @server = ' linked server name ', @optname = ' collation compatible ', @optvalue = ' true '
Go
