Dropping a user attached to a database schema

So today I was attempting to delete a SQL account from one of my servers. Easy enough I thought, deleting the account from the server, check. I go to delete the account at the database level and BAM! I get the all too familiar evil red script!

Error: 15138 The database principal owns a schema in the database, and cannot be dropped.

So whats the error actually mean? Jump over to¬†Derek Dieter’s awesome site SQL Server Planet to find out! I followed his script¬†verbatim and it worked great for me!

About these ads

2 thoughts on “Dropping a user attached to a database schema

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s