Home » Programming

Can’t delete a user? (MS SQL 2008 error 15138)

11 August 2009 One Comment

If you try to delete a user from SQL Serve 2008 and receive this error:

the database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error :15138)

like the error message suggests, that has something to do with a schema related to it.

The easiest way to solve this problem is first to delete the schema attached to the user, then delete the user. It should work.

One Comment »

Leave your response!

You must be logged in to post a comment.