Post reply

syntax for connecting from one SQL server to another SQLl Server

  • 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

  • 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]

  • January 6, 2005 at 5:54 am

    #536148

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

  • 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?

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply