Post reply

query remote server WITHOUT using sp_addlinkedserver?

  • October 21, 2009 at 1:20 pm

    #227285

    Is there any way to do this? A developer asked me this today, I was stumped. I know it's an uncommon idea, but now he peaked my interest. I know I've done this before in the distant past, but I can't remember if I did it through the query analyzer or through some other means. I'm stumped. If anyone can provide me with an answer, and if yes, an example, that would be very helpful.

  • October 21, 2009 at 2:04 pm

    #1069107

    Check OpenDatasource in BOL.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • October 21, 2009 at 2:06 pm

    #1069110

    thanks.

    I actually found it after I posted this. I just used an openrowset

    I knew I had done this before.

    thanks for the reply though.

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

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