Cannot create database diagram in SQL Server Management Studio
|
|
|
Question / Problem
|
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.
|
Solution
|
First thing make sure your database is compatibility level 90 or higher
by
Database properties -> options
then execute the following query
Syntax
ALTER AUTHORIZATION ON DATABASE::<Database name> TO <User name>
Example
ALTER AUTHORIZATION ON DATABASE::Northwind TO Sa
|
Applies to |
|
Microsoft SQL Server 2005
|
Rank It |
|
