Post reply

management Studio

  • May 8, 2013 at 2:28 pm

    #272446

    Anyone knows if I only install SQL management studio, not the full version of an instance, can I use linked server to connect to Other SQL servers or Oracle servers? or through ODBC to connect to servers?

    Thanks,

  • May 8, 2013 at 2:35 pm

    #1613535

    a linked server is a server object in master.sys.servers...so once you connect with SSMS, whether it's local or remote instance of SQL, you can create or use linked servers that are on that SQL instance; linked servers don't exist in the client application SSMS. so is that the question?

    if you don't want to use a SQL Server as the pass thru for your queries, but still want to connect to Oracle, you'd probably use TOAD or SQL Developer and connect to your Oracle directly, right?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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