Working with SQL Server 2000 Diagrams

  • Article

SQL Server 2005 database diagrams and SQL Server 2000 database diagrams are created and rendered differently. Because of these differences, SQL Server Management Studio cannot work with SQL Server 2000 diagrams. Use SQL Server 2000 Enterprise Manager instead.

When a database that contains diagrams is upgraded to SQL Server 2005, the diagrams will be upgraded when the diagrams folder is first opened.

To upgrade database diagrams, the user must be a member of the db_owner database role, and upgrade the database must be in SQL Server 2005 compatibility level. If the database is set to the compatibility level of an earlier version, you might receive the following error message:

"Database diagram support objects cannot be installed because this database does not have a valid owner."

To continue, use Management Studio or sp_dbcmptlevel to set the compatibility level to SQL Server 2005.

See Also

Other Resources

Designing Database Diagrams (Visual Database Tools)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

14 April 2006
New content:
  • Added information about the effects of compatibility level.