Post reply

Referencing tables in another database

  • June 4, 2011 at 2:09 pm

    #148116

    I Need to reference tables or views in another database on same SQL Instance.

    Any help would be great. I believe I should be able to do this without a Linked Server, but am not sure.

    Regards

    Michael J Hilligas

  • June 4, 2011 at 6:00 pm

    #1334089

    As long as you're referencing within the same instance (as you mentioned) Edit: [and the user has the permission to access this object], you could use the three-part name to reference an object: e.g.

    SELECT col1 FROM MyOtherDb.dbo.MyReferencedTable


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • June 5, 2011 at 12:04 pm

    #1334146

    Thanks.

    It Works Fine

    Regards

    Michael Hilligas

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

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