Exporting Database Diagrams from SQL Server Management Studio

A question that arose at one of the stops on the SQL Server 2005 Launch Tour was How do I export database diagrams I create in SQL Server Management Studio to another application? The answer to this question depends on what you want to do with the diagram after you export it. 

If you want to be able to change it and then re-import it back into SQL Server Managament Studio, there is no easy way to do so.  For this functionality you are better off using Microsoft Office Visio 2003 to create the diagrams and maintain them in that environment. 

If you need to export the database diagram for inclusion into a document or in some way preserve the current image of the database, you can copy the diagram to the clipboard by selecting Copy Diagram to Clipboard from the Database Diagrams menu option.  Once the diagram is copied to the clipboard you can paste it into any application that supports images such as Microsoft Office Word, PowerPoint and others.