>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
trying to link the second instance a a linked server with this sintax but gives me an err

sp_addlinkedserver
@server = 'prueba',
@provider = 'SQLOLEDB',
@datasrc = 'myserver\myinstance02'

Server: Msg 15429, Level 16, State 1, Procedure sp_addlinkedserver, Line 72
'(null)' is an invalid product name.


can you help me