>>>Yeah It appeals me, using smaller databases and creating views would be ideal.
>>>
>>>Any comments experts ?
>
>
>>No experts I guess!!!
>
>:)
>good point raised by you though !
>u must have implemented ur design till now. how is it doing?
>we have come across a similar prob and we have freezed upon one large database for multiple systems.

We did implement a bunch of databases with views in a main database, this seems to be working pretty well, there are problems though, when you change the underlying table, the view does not reflect that even if you do "SELECT * FROM TABLE", the new columns don't show up in the view. So we have a script that runs periodically in the server that updates all views that have underlying tables that look different.

But other than that it is great, we can move tables around in the different databases and we just regenerate the view and all works great.

Fabian