Enter your email address:


feedburner count

SQL 2000 - SQL 2005 Database Upgrade : Database Diagrams problem

Labels:

I restored Sql Server database 2005 from Sql Server 2000, then I want to add a new diagram, but when I click "Database Diagrams" there an error message "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. ". Follow these steps to resolve this problem:
1. Right Click on your database, choose properties
2. Goto the Options Page
3. In the Dropdown at right labeled "Compatibility Level" choose "SQL
Server 2005(90)"
4. Press OK.

The alternating method, you can run sthis store procedure:

EXEC sp_dbcmptlevel 'yourDB', '90';
GO
ALTER AUTHORIZATION ON DATABASE::yourDB TO "yourLogin"
GO
USE [yourDB]
GO
EXECUTE AS USER = N'dbo' REVERT
GO





blog comments powered by Disqus