I agree I have not really understood why the schema concept is there. It has caused more problems for me that it has been useful. We have a research dept that I got tired of creating hundreds of views for so I finally gave them Enterprise Manager and only gave the rights to create views. That was great until someone quits and no one else has access to thier views. Now I have to go in and change ownership on each view to someone who is currently working here.

I think using the Personal edition is the best answer for developers. It allows developers to have thier own environment and I don't have to worry about them even possibly wrecking production environment. Also they might learn a thing or two about SQL Server in the process.

Ross