How to connect to a DB on another server using SQL? -

How to connect to a DB on another server using SQL? -

i trying write sql script pull info on info stored (i.e. server , db in). have part pulling info , putting separate db on same server, much of info i'm wanting collect on other servers. there way in same script connect several different db's on several different servers info want. i'm trying names, emails , phone numbers people in our various db's. here have far:

if object_id('tempdb..#trainingsessioninfo') not null drop table #trainingsessioninfo if object_id('psbackup.dbo.investigouniversitysessions','u') not null drop table psbackup.dbo.investigouniversitysessions declare @startdate date = null ,@enddate date = null set @startdate = '1/1/2014' set @enddate = '6/17/2014' --exec spgettrainingsessioninfo @startdate,@enddate create table #trainingsessioninfo(cntid int,datdate datetime,strdesc varchar(255),strfirmid varchar(255),strtrainer varchar(255) ,meetingid varchar(255),attendees int) insert #trainingsessioninfo exec spgettrainingsessioninfo @startdate,@enddate create table psbackup.dbo.investigouniversitysessions (lngsessionid int ,struserid int ,strfirmid varchar(255) ,cntif int ,strdsnserver varchar(255)) insert psbackup.dbo.investigouniversitysessions (lngsessionid,struserid,strfirmid,cntif,strdsnserver) select lngsessionid ,struserid ,strfirmid ,cntid ,s.strdsnserver tbltrainingsessionsignup tss bring together sites s on s.firmid = tss.strfirmid tss.lngsessionid in(select cntid #trainingsessioninfo) select * psbackup.dbo.investigouniversitysessions order lngsessionid desc,strfirmid,struserid desc

you can utilize linked server object. linked server objects on single central sql server machine working on must configured in advance 1 time set can access remote info usual syntax:

select top 10 * [linked server name].[remote database name].[schema].[table]

no alter required on remote servers.

sql sql-server