I am just volunteering to teach this class. and I have not used sql 2005

I am using all help I can get.

Thank you

Thank you for all your help. I created a db for each students and assigned their ownership.

my next question is on how to get a db schema, and a relationship...

Yes, each student has their own log in( user & pwd). & they should have their own db. so that they can create tables and modify it as we go...

I assigned the students to one database (master) and during class they were all working on the same db.

how can I change their db ownership without having to recreate the...

Thanks for your help.

it is silly but I realized that I was using the server user & pwd instead of the one I created in the EM to access...