Ok Guru''s This one I can''t figure out It seems like a hard one

• scrocker

  SSC Veteran

  Points: 231

  More actions

  March 7, 2005 at 8:49 am

  #66973

  :crazyk here is the scoop, I have two database servers we will call them s1 and s2.  I have migrated data from one server to another server.  What I would like to do is run a tsql statement against 2 servers and 2 databases.  Is this even possible

  Any thoughts would be greatly appreciated

• PW-201837

  SSC-Insane

  Points: 20805

  More actions

  March 7, 2005 at 9:02 am

  #545743

  See the "Linked Servers" topics in BOL.

• Adam Wilbur

  SSCertifiable

  Points: 7001

  More actions

  March 7, 2005 at 4:43 pm

  #545794

  Use OpenQuery or OpenRowset

  
  
  A.J.
  DBA with an attitude

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  March 8, 2005 at 2:33 am

  #545831

  Also see the SELECT topic in BOL.

  (note that the full syntax of select is FROM server.database.owner.object)

  Yet another option is to use remote procedure calls - there's many ways to skin this cat.

  /Kenneth