Menu
I am having trouble printing my diagrams, I seem to be getting portions of the diagram blocked out, etc. I've tried several different computers, printers, and databases, so it seems to be a problem with SSMS Express itself.
Is this just the way it is?
Are there any decent workarounds, or does anyone use a 3rd party product (preferably free or cheap) that can cleanly integrate with SQL Server?
722
Select Page Size and Orientation - A3 and Landscape are most likely best options. And Print Scale - this is the % value that should hopefully enable you to fit all tables onto one page. The additional note about the Print Scale makes this a very useful answer.
Right click on the database containing the diagrams. Click on All Tasks then on "Export data". The Import / Export option will be displayed, click Next. Define the source and then click Next.
Within the diagram, do a Copy Diagram to Clipboard from the edit menu, and then paste into a new Microsoft Word document. From there, you can scale the drawing as you wish.
If you have a printer capable of printing to 11 x 17 paper, this works well. I have been able to print schemas with 30 tables this way onto a single page, and the table objects are very nearly actual size.
89
Right click in a space area then choose " Copy diagram to Clipboard ".
Go to "Paint" paste it then print it.
32
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
