Post reply

Access table from different instance

  • December 14, 2012 at 11:37 am

    #393800

    hello experts,

    i want to write a select query which will access table from different instance, but cant create linked server on tht server bcos thts a production server.

    please advice

    thanks

  • December 14, 2012 at 11:57 am

    #1568797

    Not sure if using OPENROWSET would help. Might depend on security settings. Look it up in Books Online (aka BOL) and see if that will work...

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • December 14, 2012 at 12:06 pm

    #1568802

    i believe openrowset still require linked server name to pass.

    dirent server name wont work in tht right?

  • December 14, 2012 at 12:17 pm

    #1568806

    That's why I suggested you look at BOL, as I can't recall the exact syntax, but I do know that OPENQUERY has to have a LINKED SERVER NAME, while OPENROWSET uses a connection string. I just don't know if using OPENROWSET can be locked down so that no temporary linked servers can be created via OPENROWSET.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • December 14, 2012 at 12:24 pm

    #1568807

    ok thanks a ton for your help 🙂

  • December 16, 2012 at 6:04 pm

    #1568984

    Zeal-DBA (12/14/2012)

    ok thanks a ton for your help 🙂

    Did openrowset works for you?....I am curious.

    SueTons.

    Regards,
    SQLisAwe5oMe.

  • December 19, 2012 at 2:13 am

    #1569934

    yeah OPENROWSET works, it requires connection string, it does'nt require linked server to configure, but "ad hoc distributed queries" should be enabled through sp_configure.....

    thank you so much

Viewing 7 posts - 1 through 6 (of 6 total)

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