Your customer urge you to drop a user from the MsSQL Server database, but you stuck with the following related error:

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

If you don't have access to the SSMS to see which schema or objects …


Have you ever suffered from a slow SQLServer database? Someone love to run that heavy query in the database? Resource Governor to the rescue. You can set a few rules on how users (connections actually) will use the server/database resources based on a few things.

First things first, if …