I'm using MS SQL Server Management Studio 2005 to manage both SQL 2000 and SQL 2005 server. When I connect to SQL 2000 Server database and try to do a Database Diagram, I got the following error:
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.
When a database containing diagrams is upgraded to SQL Server 2005, the diagrams will be upgraded the first time that the diagrams folder is opened.
You must be a member of the db_owner database role to upgrade database diagrams.
Any idea how to resolve this? I do not have admin rights to the SQL Server 2000.
Use SQL Server 2000 to administer the on the SQL Server 2000 Server stored diagrams.Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment