Post reply

Cross Server Query Syntax

  • December 4, 2002 at 12:10 pm

    #79497

    Is it possible to do a cross server query in SQL Analyzer? If so, can someone show me the syntax for addressing separate servers with named instances and potentially different logins. I would like to create a cross instance view. Is that possible?

    Thanks

  • December 4, 2002 at 12:33 pm

    #443139

    Boy this seems to be the question of the day today. You can define your foreign server as a linked server and use 4-part names to select from tables/views.

    Or you can use OPENROWSET and pass all your connection info to the remote server and get your goods back.

  • December 4, 2002 at 12:49 pm

    #443142

    quote:

    Boy this seems to be the question of the day today. You can define your foreign server as a linked server and use 4-part names to select from tables/views.

    Or you can use OPENROWSET and pass all your connection info to the remote server and get your goods back.

  • December 4, 2002 at 12:50 pm

    #443143

    I get it! Works Great! Thanks..

  • December 4, 2002 at 12:52 pm

    #443145

    Works Great! Thanks!

Viewing 5 posts - 1 through 5 (of 5 total)

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