Thursday, 7 April 2011

Printing database diagram in a single page from SQL Server Management Studio

When you try to print database diagrams in SQL Server Management Studio most of the time things end up printing the diagram multiple pages. There is a work-around to this.

Right-Click on the diagram and select the option 'View Page Breaks'. Now you can rearrange your tables to avoid page breaks. Print it once you move all your tables into a single page.

"View Page Breaks" option is also available in "Dtabase Diagram" menu as well.

No comments:

Post a Comment