Transact SQL :- Error – Msg 15138 – “The database principal owns a schema in the database, and cannot be dropped”

Background Cleaning up a database as we move it from Development to Production. Recreate Drop User SQL Error Msg 15138 Error Text Error Image   Troubleshoot Metadata sys.schemas SQL Output Explanation Schema db_datareader The owner for the db_datareader schema has been assigned to a database account, other than itself Remediate Change Schema Owner ALTER AUTHORIZATION … Continue reading Transact SQL :- Error – Msg 15138 – “The database principal owns a schema in the database, and cannot be dropped”

SSMS – Error Message – “Property Owner is not available for Database”

Background Trying to access the database property on one of our databases. Error Error Message Syntax Property Owner is not available for Database '[database]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo) Sample Property Owner is not available for Database '[AdminDB]'. This property may … Continue reading SSMS – Error Message – “Property Owner is not available for Database”