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

I opened SQL Server Enterprise Manager, created a new diagram, added my tables, created a number of relationships, and went to save it.

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.

SQL Server™ code-named “Katmai,” the next release of Microsoft® SQL Server, will help companies access and manage rapidly increasing volumes of data for mission-critical applications, increase their ...