syntax for connecting from one SQL server to another SQLl Server

• amira-193615

  SSC Veteran

  Points: 216

  More actions

  January 6, 2005 at 3:35 am

  #61213

  Hey. In a procedure that is stored on one SQL server I need to search trhough tables that are only part of another SQL server on another machine.

  what is the syntax for the connection?

  thanks

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  January 6, 2005 at 3:50 am

  #536135

  Please refrain from multi-posting. See my answer here

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=153940

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]