FAULT: The user owns objects in the database cannot be dropped

[John41]

Hello,

Urgent

We have a problem to remove a mssql database of a user.
What can I do?

ERROR:

Unable to delete database user: The user owns objects in the database cannot be dropped

John

 

[sergius]

what plesk version?

 

[John41]

Originally posted by sshigin
what plesk version?

Plesk 7.5.6

Thanks

 

[poquelicot]

I'm using this version of Plesk and I have the same problem... I've reach the quota of databases on my hosting service and I'm blocked !

 

[kami@]

Go to mssql webadmin for this database and delete all tables owned by this user and the user itself

 

[poquelicot]

I found a solution : I had to drop every procedures owned by the user, and it worked !

Thanks for your reply, hope it will help some people !

 

[Traged1]

You might also want to try dropping all "User Defined Functions".