Shulou(Shulou.com)05/31 Report--

How to achieve cross-server connection in MSSQLSERVER? in view of this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

The MSSQLSERVER cross-server link server creation method copies the code as follows:-- declare variables Declare @ svrname varchar, @ dbname varchar, @ sapassword varchar-- before execution Modify the following variables 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''-- add linked server exec sp_addlinkedserver @ server = 'linked server name', @ srvproduct='',@provider = 'SQLOLEDB'' @ datasrc = @ svrname, @ catalog = @ dbname-- add linked server remote login exec sp_addlinkedsrvlogin @ rmtsrvname = 'linked server name', @ useself = 'False',@locallogin =' sa',@rmtpassword = @ sapassword-- configuration parameter 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

This is the answer to the question about how to achieve cross-server connection in MSSQLSERVER. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.