Home Forums Programming General query other databases from the information in another database RE: query other databases from the information in another database

  • pjuster (3/25/2013)


    Hi,

    I have a database called databaseA with a table called, otherdbs with two columns

    server databasename

    server1 parts

    server2 parts

    I would like a query that queries databaseA and table called otherdbs, which then uses the server and databasename to issue another query on each of the databases.

    Apologies for the lack of details, is this possible? any hints on where to start would be brilliant.

    Yes, using dynamic sql along with linked servers.