Export (0) Print
Expand All
1 out of 6 rated this helpful - Rate this topic

Working with SQL Server 2000 Diagrams

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, 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.