Can we pull data from 2 different servers with a single query.

• jdk1432_tony

  SSC Enthusiast

  Points: 123

  More actions

  November 4, 2008 at 4:11 am

  #214815

  Hi Experts, If anyone knows how to retrieve data from 2 servers with a single query, please help.

  I am trying to pull data from the below servers.

  1). Server: 10.10.30.215, DB: FY09_PING

  2). Server: 10.10.30.223, DB: FY09_PINGOTP

• naveeng

  Newbie

  Points: 5

  More actions

  November 4, 2008 at 4:40 am

  #893523

  you can user linked server funcationality in which you will need to link server 2 under server 1

• SQLZ

  SSChampion

  Points: 12872

  More actions

  November 4, 2008 at 4:40 am

  #893525

  Have a look at linked servers in Books Online.

  Once you've setup a linked server you can join the two tables, by using fully qualified names.

  e.g. select * from some_server.database_name.dbo.table_name

  Karl
  source control for SQL Server

• jdk1432_tony

  SSC Enthusiast

  Points: 123

  More actions

  November 4, 2008 at 10:30 pm

  #894051

  Hi SQLZ, Could you help me to share the link for "linked servers"

• Sanjay Rohra

  Ten Centuries

  Points: 1159

  More actions

  November 4, 2008 at 10:49 pm

  #894057

  This should help:

  http://www.sqlservercentral.com/articles/Distributed+Queries/anintroductiontolinkedservers/1366/

• jdk1432_tony

  SSC Enthusiast

  Points: 123

  More actions

  November 4, 2008 at 11:12 pm

  #894060

  Thanks Sanjay