I'm using Sql Server 2005 Management Studio on my client machine against Sql Server 2000 databases. For some reason, when I right-click to create a new diagram, the option isnt available.

In Object Explorer, expand the Database Diagrams folder. Right-click the database diagram that you want to delete. Choose Delete on the shortcut menu. A message prompts you to confirm the deletion.

From Object Explorer, expand a database node. Expand the Database Diagrams node under the database connection. Select Yes when prompted if you want to set up database diagramming. [!NOTE] This will ...

SQL Servers allow the import or export of database diagrams to another database. All the information related to a database is stored in the dtproperties table. Therefore, to import or export a ...

2. SQL Server Management Studio If we are talking about database management tools, the best choice is SQL Server Management Studio. It combines a powerful set of user-friendly graphical tools and ...