,
Share this with your friends 
 

Cannot create database diagram in SQL Server Management Studio

0 ratings Views 537 
Author: krish (krishna kumar)  View Profile |  View other solutions by this author

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

Login to rank it

Report


Advertisement