>>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

When and why do you see the need for attaching/detaching databases?
Regards,
Viv

>
>
>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.
>>