>>Hi,
>>
>>I think that theoretically it is possible to create a report (from VFP or maybe even other tools) that gets/pulls data from various SQL Server databases (even hosted by different SQL Servers).
>>But I was wondering, has anybody done it and do you find it practical?
>>
>>I am "drafting" an approach of creating a report for a corporate that shows how the data is used in misc branches.
>>
>>TIA
>
>Dmitry,
>the others have shown you that you can refer to multiple databases in one SQL Server instance by just using the database name. However, if you want to have a single query running from multiple SQL Server instances, you will first need to create a link to the other instances, then you can refer to each instance in your query. This link might help:
https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/create-linked-servers-sql-server-database-engine or you can Google: SQL Server Linked Servers
Thank you, Frank.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
