You might look into Linked Servers. You can link a "client" server to a "master" server. This will allow you to call a stored procedure or view on a "master" server that can query data from the client server and return the data with one call from your application.
>We recently separated to companies of out system and put the second one in a different named instance of sql server , now we are facing the problem of a report which gets data from the two companies.
>
>how can i get the data from the two instances, and remeber that getting the data in the actual instance ain't the problem, getting the data from the named instance it is.
>
>some usefull info
>
>we're using ODBC
>the two instances reside on the same server
>
>TIA