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 3 (of 3 total)

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy