manually editing database from Enterprise Manager

[IR0NMAN]

Hi, i'm using Plesk 7.5 for Windows and MSSQL 2005.

I'm trying to delete a database I created but it won't let me because "the database principal owns a database role and cannot be dropped". I'm a logged in as admin and _I_ created the database myself. Now, how do I get rid of this database?

Can i use SQL enterprise manager to drop the whole database or it is going to screw up Plesk? This is a production server so I'm not really able to experiement hehe.

Help!!!

 

[JackL]

Don't perform deletion from SQL manager instead all operations must be performed through Plesk interface

John S.G.

 

[IR0NMAN]

Thanks for the reply! Good thing I waited before deleting the database with SQL Manager.!Any idea how I could fix this problem? is the login name "admin" the main administrator or only a super admin has every permissions?

 

[Gris@]

Open Management Studio and check what user of this database has db_owner role
Give dbo db_owner role