Hi

You could buy each a copy of developer edition and let them run it on their
own PCs! A cheaper solution would be to use MSDE.

John

"db_happy" <database@freemail.gr> wrote in message
news:b625e551.0407110220.540e1260@posting.google.c om...
> Hi
>
> I need some design info. Say that I need to create an educational lab
> for databases with SQL Server. I need all the users to be able to
> execute common SQL commands ( create - alter - drop table , insert ,
> update , delete ) and each user have his own space ( users not able to
> see others data and a limit say of 2 MB) . The most obvious solution
> is to create ( if I have 100 users ) , 100 login account ( SQL Server
> Accounts ) , then create 100 databases , and assign each user to one
> of this account with database role db_datawriter. Is this the best
> solution or there is another way to do it ?
>
> Thanks