accessing databases across servers

If two databases are on different server instances, you can establish a linked server before querying:

--1. Establishing a linked server, specifying a data source through @datasrc, suitable for linking to many other databasesEXECMaster.dbo.sp_addlinkedserver@server =N'Link',                                   @srvproduct='Ms',                                    @provider=N'SQLNCLI',                                                                       @datasrc=N'remote server IP, Port' EXECMaster.dbo.sp_addlinkedsrvlogin@rmtsrvname=N'Link',                                    @useself=N'False',                                    @locallogin=NULL,                                    @rmtuser=N'User name',                                    @rmtpassword='Password'  --2. Then run the following query, for example: Database 2 on the remote serverSelectr.id, R.bjname,Count(*) fromDatabase 1.dbo.rooms RInner Join [Link]. Database 2.dbo.renshu rs onR.id=Rs. BjidGroup  byr.id, R.bjname

accessing databases across servers