>I got prety much the same scenarion in VFP, so I am really curious how all this can be implmented
>with NET/MSSQL.


I will be investigating how I can attach/detach databases to/from a server instance. Seems possible, but I still have to fiddle a (big) bit to test it. Then there's the problem when to detach a database. The first user has to attach it, the second etc does not have to. But I like a sort of auto-detach. Seems possible but all connections to a database have to be kept open. And it seems that the best is Open/get or write data/close


for an intro see message#1341366

__
>BTW Since accounting data are already physically 'partitioned', it is highly unlikely you would ever hit 2gb limit
>(if it did not happen up to now.)
>In my case, accounting with multiple company/year databases would be defenetely last thing to move to anything else.
>