I'm normally a MySql user but looking at what MS Sql can do. Is there a role that can drop all databases?
Take a look at what MSDN and BOL have to say about the DROP DATABASE command:
Hope that helps.
Devshed is a Developer Shed Property, Owned by Jim Boykin, CEO of Internet Marketing Ninjas
Dev Shed Forums
© 2003 - 2014 by Devshed, LLC. All rights reserved