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

But what I did was that I created one database and I set some students ownership to it. and the other students to the master db.

so now I'm stuck with two db full of data entered by different students.

When they should each have their own.

should I just create one for each of them & then have them reexecute their queries next class?

or can they create a db from the query analyzer?

Thank you so much.