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.
我在打印我的图时遇到了麻烦，我似乎把图的一部分屏蔽了，等等。我尝试了好几台不同的计算机、打印机和数据库，所以SSMS Express本身似乎有问题。
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?
是否有合适的解决方案，或者是否有人使用第三方产品(最好是免费的或便宜的)，可以干净地与SQL Server集成?
7 个解决方案
#1
80
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.
在图中，从编辑菜单中复制图到剪贴板，然后粘贴到一个新的Microsoft Word文档中。从那里，你可以按自己的意愿缩放这幅画。
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.
如果你有一台能够打印到11×17纸的打印机，这很好用。我已经能够以这种方式在一个页面上打印30个表的模式，而表对象几乎是实际大小。
#2
16
Right click in a space area then choose " Copy diagram to Clipboard ".
右击空格，然后选择“复制图到剪贴板”。
Go to "Paint" paste it then print it.
点击“油漆”粘贴，然后打印出来。
#3
10
Manual Solution: 1- Open the diagram in SSMS 2- Right-Click and select 'View Page Breaks' (If your diagram is displayed across multiple pages, go to #3) 3- drag-and-drop all of you table items into one page space (you are done!) 4- Use the Zoom drop-down control to view your tables (i.e. Fit to, 10%, ... 100%) 5- save As Whatever name you want 6- Print your diagram, and it will fit to one page.
手动解决方案:1 -在地对地导弹中打开图2 -右键单击并选择“查看分页符”(如果你的图显示多个页面,去# 3)3 -拖放你们表项为一页空间(你做!)4 -使用缩放下拉控件查看表(例如适合,10%,…100%) 5-保存为你想要的任何名称6-打印你的图表，它将适合一页。
-Each one teach one,
有一个教一个,
#4
6
Use the page Setup and Print Scale
使用页面设置和打印比例
When you have your drawing, Go to File | Page Setup
当你有你的绘图，去文件|页设置
From there, you can determine the paper size, orientation and most importantly the Print Scale
从那里，你可以确定纸张的大小、方向和最重要的打印比例
Once you have shown your page breaks, play with the print scale so that it fits on your chose pagesize.
一旦你展示了你的页面休息，播放打印规模，使它适合你的选择页。
then everyone who views the diagram can print directly from SMSS without needing to copy to clipboard and use other programs to print...
然后，每个查看图的人都可以直接从SMSS中打印出来，而不需要复制到剪贴板，并使用其他程序来打印……
#5
5
I have experienced related issues when printing multiple pages of SQL diagrams and finally found an acceptable solution that doesn’t involve copying the diagram elsewhere. My main issue being the auto-recalculation of the page breaks placement as you try to print.
我在打印多页SQL图时遇到过相关问题，最后找到了一个可接受的解决方案，不需要在其他地方复制图表。我的主要问题是，当您尝试打印时，页面的自动重新计算会中断位置。
First, in Page Setup, set your orientation / paper size / print scale
首先，在页面设置中，设置方向/纸张大小/打印比例
1) Enable View Page Breaks
1)启用视图分页符
2) Arrange the diagram in the pages like you want them (alternatively know that you can drag the blue page break lines also)
2)将图表按你想要的方式排列(或者知道你也可以拖动蓝页的断线)
3) On the bottom-right corner of the last page (bottom-rightmost) place a text annotation with a bit of text (your company name, etc) and locate it somewhat close to that corner.
3)在最后一页(右下角)的右下角(右下角-右上角)放置一个带有文本的文本注释(您的公司名称等)，并将其放置在靠近那个角落的地方。
4) Try recalculating the page breaks again and see that they stay on the same place or close enough to where you want them.
4)试着重新计算分页符，并确保它们保持在相同的位置，或者离你想要的位置足够近。
5) Print & enjoy!
5)打印和享受!
Note: I am using SSMS 2012 which I was hoping would finally solve this automatically but behaves like prior versions - at least this workaround lets me lay diagram properly on the printed page.
注意:我正在使用SSMS 2012，我希望它最终能够自动地解决这个问题，但它的行为与以前的版本类似——至少这个解决方案可以让我在打印的页面上正确地放置图表。
#6
2
Not sure if this will help you or not, but I usually print to PDF via CutePDF Writer.
我不确定这是否会对您有所帮助，但我通常通过CutePDF Writer打印成PDF格式。
#7
0
Suprised! Why would you want to export it to word or use CutePDF?
很惊讶!为什么要导出为word或使用CutePDF?
- Right click on the white background on the diagram choose View Page Breaks.
- 右键单击图中的白色背景，选择查看分页符。
- From File choose print.
- 从文件选择打印。
It works on my pc! :-]
它在我的电脑上工作!:-)
#1
80
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.
在图中，从编辑菜单中复制图到剪贴板，然后粘贴到一个新的Microsoft Word文档中。从那里，你可以按自己的意愿缩放这幅画。
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.
如果你有一台能够打印到11×17纸的打印机，这很好用。我已经能够以这种方式在一个页面上打印30个表的模式，而表对象几乎是实际大小。
#2
16
Right click in a space area then choose " Copy diagram to Clipboard ".
右击空格，然后选择“复制图到剪贴板”。
Go to "Paint" paste it then print it.
点击“油漆”粘贴，然后打印出来。
#3
10
Manual Solution: 1- Open the diagram in SSMS 2- Right-Click and select 'View Page Breaks' (If your diagram is displayed across multiple pages, go to #3) 3- drag-and-drop all of you table items into one page space (you are done!) 4- Use the Zoom drop-down control to view your tables (i.e. Fit to, 10%, ... 100%) 5- save As Whatever name you want 6- Print your diagram, and it will fit to one page.
手动解决方案:1 -在地对地导弹中打开图2 -右键单击并选择“查看分页符”(如果你的图显示多个页面,去# 3)3 -拖放你们表项为一页空间(你做!)4 -使用缩放下拉控件查看表(例如适合,10%,…100%) 5-保存为你想要的任何名称6-打印你的图表，它将适合一页。
-Each one teach one,
有一个教一个,
#4
6
Use the page Setup and Print Scale
使用页面设置和打印比例
When you have your drawing, Go to File | Page Setup
当你有你的绘图，去文件|页设置
From there, you can determine the paper size, orientation and most importantly the Print Scale
从那里，你可以确定纸张的大小、方向和最重要的打印比例
Once you have shown your page breaks, play with the print scale so that it fits on your chose pagesize.
一旦你展示了你的页面休息，播放打印规模，使它适合你的选择页。
then everyone who views the diagram can print directly from SMSS without needing to copy to clipboard and use other programs to print...
然后，每个查看图的人都可以直接从SMSS中打印出来，而不需要复制到剪贴板，并使用其他程序来打印……
#5
5
I have experienced related issues when printing multiple pages of SQL diagrams and finally found an acceptable solution that doesn’t involve copying the diagram elsewhere. My main issue being the auto-recalculation of the page breaks placement as you try to print.
我在打印多页SQL图时遇到过相关问题，最后找到了一个可接受的解决方案，不需要在其他地方复制图表。我的主要问题是，当您尝试打印时，页面的自动重新计算会中断位置。
First, in Page Setup, set your orientation / paper size / print scale
首先，在页面设置中，设置方向/纸张大小/打印比例
1) Enable View Page Breaks
1)启用视图分页符
2) Arrange the diagram in the pages like you want them (alternatively know that you can drag the blue page break lines also)
2)将图表按你想要的方式排列(或者知道你也可以拖动蓝页的断线)
3) On the bottom-right corner of the last page (bottom-rightmost) place a text annotation with a bit of text (your company name, etc) and locate it somewhat close to that corner.
3)在最后一页(右下角)的右下角(右下角-右上角)放置一个带有文本的文本注释(您的公司名称等)，并将其放置在靠近那个角落的地方。
4) Try recalculating the page breaks again and see that they stay on the same place or close enough to where you want them.
4)试着重新计算分页符，并确保它们保持在相同的位置，或者离你想要的位置足够近。
5) Print & enjoy!
5)打印和享受!
Note: I am using SSMS 2012 which I was hoping would finally solve this automatically but behaves like prior versions - at least this workaround lets me lay diagram properly on the printed page.
注意:我正在使用SSMS 2012，我希望它最终能够自动地解决这个问题，但它的行为与以前的版本类似——至少这个解决方案可以让我在打印的页面上正确地放置图表。
#6
2
Not sure if this will help you or not, but I usually print to PDF via CutePDF Writer.
我不确定这是否会对您有所帮助，但我通常通过CutePDF Writer打印成PDF格式。
#7
0
Suprised! Why would you want to export it to word or use CutePDF?
很惊讶!为什么要导出为word或使用CutePDF?
- Right click on the white background on the diagram choose View Page Breaks.
- 右键单击图中的白色背景，选择查看分页符。
- From File choose print.
- 从文件选择打印。
It works on my pc! :-]
它在我的电脑上工作!:-)