Query two different Servers

• ccmret

  Right there with Babe

  Points: 759

  More actions

  May 16, 2013 at 7:33 am

  #293970

  Is there a way to query two different servers at the same time if they aren't linked?

• Chrissy321

  SSCoach

  Points: 15763

  More actions

  May 16, 2013 at 8:50 am

  #1615838

  You can use OPENROWSET to do ad hoc distributive queries if the remote server is configured to allow this.

  http://msdn.microsoft.com/en-us/library/ms187569.aspx