>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