How do you create Linked Server

• Motomoto

  Right there with Babe

  Points: 799

  More actions

  January 25, 2012 at 9:43 pm

  #250206

  Could someone please provide steps to create Linked Server within SQL Server 2008. I want to create a link between two databases that reside in different servers and instances.

  Thanks.

• Jeff Moden

  SSC Guru

  Points: 1004553

  More actions

  January 25, 2012 at 9:52 pm

  #1438559

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

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• umasingh

  Ten Centuries

  Points: 1182

  More actions

  January 25, 2012 at 10:02 pm

  #1438561

  found nice webcast on creating linked server on ssc.

  http://www.sqlservercentral.com/articles/Video/66413/

• Motomoto

  Right there with Babe

  Points: 799

  More actions

  January 26, 2012 at 10:47 am

  #1438939

  Thank you so very much. This webcast is very useful and right to the point. Thank you again.

  http://www.sqlservercentral.com/articles/Video/66413/