Post reply

accessing data of another server

  • February 10, 2010 at 8:59 am

    #100099

    I have 2 servers. I want to access the database hosted on server A from server B.

    Anybody can please let me know how to access the database of server A from server B using SELECT statement? ( I don't want to use link server )

    Thanks in advance.

    Regards,

    Jayant G Nimje

  • February 10, 2010 at 9:25 am

    #1116937

    I don't think you will be able to access data from another server using select statement without linked server connection. You can replicate the objects if you want copy of the data, that's whole different point.

    EnjoY!

  • February 10, 2010 at 2:48 pm

    #1117221

    GT-897544 is right. You will have to add the remote server as a linked server and then access the data on it using its four-part name.

    Joie Andrew
    "Since 1982"

  • February 10, 2010 at 3:00 pm

    #1117232

    The question was already answered, you cannot.

    May I ask you why do you avoid Linked Servers?

    They are the way to talk to remote servers without having to duplicate the data on the primary server.

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • February 10, 2010 at 3:03 pm

    #1117235

    You could use the openrowset command, instructions from the MSDN site:

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

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

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