SQL 2005 Error: Property Owner Is Not Available For Database

This is a particularly annoying error, whereby the db_owner property displayed in the SQL 2005 GUI for a particular database doesn’t reflect the actual owner of the database. To fix this you need to set the owner property for the database using the following SQL query:

USE <DatabaseName>
EXEC sp_changedbowner 'sa'

This is useful if you get the following error in (MSSQL) SQL 2005:

Property owner is not available for database ‘database name’

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)

Leave a comment

Your email address will not be published. Required fields are marked *