T-SQL to get data from 10 different Linked Servers.

• Ajit-297150

  Mr or Mrs. 500

  Points: 593

  More actions

  November 23, 2007 at 10:12 am

  #75817

  Hi Folks,

  We have 10 different servers.

  Each server has the same set tables. Now we need to collect data of say 2 tables from each server to a new server.

  What is best way to do this acitivity.

  We have created linked servers from the new server to each server.

  Any suggestion will help.

  Thanks.

• joemai

  Hall of Fame

  Points: 3496

  More actions

  November 23, 2007 at 10:54 am

  #753679

  If I understand correcly, I normally run a query like this assum that I already linked the servers:

  select * from tablea

  union

  select * from [111.11.1.1].db_name.dbo.tablea

  union

  select * from [111.11.1.2].db_name.dbo.tablea

  union

  select * from [111.11.1.3].db_name.dbo.tablea

  union

  select * from [111.11.1.4].db_name.dbo.tablea

  and etc...