>>I have an application that uses a few databases SYSTEM, OFFICE, SALES, PEOPLE etc. There was no problem (till today) with such architecture cos VFP local view can handle tables from diffrent databases and VFP transaction works too.
>>Now I want to upsize this application to SQL Server (user interface will be the same). I noticed that remote view can handle only one conection so I can't easy create remote view that merges data from tables of different databases.
>>The question is:
>>should I in SQL create one database that merges all my tables or am I something missing.
>
>You can create a single database with several table-spaces
>
>Arnon

Hi Arnon !

The problem is that my application is one from family of applications,
Each application can be sold separatly and has own set of databases for example.
Payroll apllication - SYSTEM-OFFICE-PEOPLE
Accouting application - SYSTEM-OFFICE-ACCOUNTING-PAYMENTS
Sales application - SYSTEM-OFFICE-SALES-PAYMENTS.

You can see modular structure - if database PEOPLE is changing there is no influence in other databases. So programmers of another application even don't know that something was changed. If it was only one database they will have to update its structure.

More precisely saying the question is:
Can I create such modular structure using SQLserver. I think I can't, because I noticed that remote view can handle only one conection so I can't easy create remote view that join data from tables of different databases. I thinks so, but I am new to SQLserver technology and I hope that I am wrong.

Greetings