Archive for May, 2007
Problem dropping a user in SQL 2005
May 15th, 2007Today I’ve encountered a problem trying to drop a user from a database. I kept getting this error:
Msg. 15138 The database principal owns a database role and cannot be dropped
So it looked like the user owned a database schema. To find out the schemas that a user owns I’ve used this query:
SELECT * […]
