syntax for connecting from one SQL server to another SQLl Server

• amira-193615

  SSC Veteran

  Points: 216

  More actions

  January 6, 2005 at 3:34 am

  #162976

  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:49 am

  #536134

  Have a look at "linked server" or OPENQUERY in BOL.

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

• amira-193615

  SSC Veteran

  Points: 216

  More actions

  January 6, 2005 at 5:54 am

  #536148

  thanks, and sorry about double post, it was not intentional

• Roy-262336

  SSC Rookie

  Points: 40

  More actions

  December 15, 2005 at 6:04 am

  #609703

  I need to do the same thing, I have linked servers but still get "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."

  Any ideas?