InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 11:48:54 GMT20http://www.sqlservercentral.com/Forums/Topic1013196-391-1.aspx[quote][b]HH-489628 (3/25/2013)[/b][hr]Doing "Copy Diagram to Clipboard" and pasting into Word used to work for me in MS Word 2007. However, it does not appear to work with Word 2010. I just get an outline of a table, but the columns are not visible. Any suggestions on how to copy a diagram into Word 2010 would be appreciated.[/quote]Actually, it's not a problem with Word 2010. After more testing, the culprit appears to be Remote Desktop. The pasting does not work only if I copy the diagram in a remote desktop window and try to copy it in a Word that's running on my local box. The work-around is to run MS Word on the box where SSMS is running.Mon, 25 Mar 2013 15:09:42 GMTHH-489628http://www.sqlservercentral.com/Forums/Topic1013196-391-1.aspxDoing "Copy Diagram to Clipboard" and pasting into Word used to work for me in MS Word 2007. However, it does not appear to work with Word 2010. I just get an outline of a table, but the columns are not visible. Any suggestions on how to copy a diagram into Word 2010 would be appreaciated.Mon, 25 Mar 2013 11:08:21 GMTHH-489628http://www.sqlservercentral.com/Forums/Topic1013196-391-1.aspxSurprised this is the first time I have seen this question because I have always had this problem in SQL Server even from earlier releases. It was never fixed by MS and I never found a "real" solution although I found a work-around.Put a tiny x in the lower right corner of every diagram page. That forces the print mechanism to think the diagram takes up the entire page and it doesn't try to format the page for you.Sun, 06 Jan 2013 21:56:44 GMTcrapper_mailhttp://www.sqlservercentral.com/Forums/Topic1013196-391-1.aspxHey Kurt -- I was definitely in the same boat, actually exporting to Visio when I needed to print. I still find exporting to be pretty important to do, as I often lose the most current version of the diagram through backup/restores when going from DEV to STAGING to PRODUCTION and the other way sometimes too.Have you tried the suggestion to place an entity near the top and bottom (and possibly sides) of the page boundaries (near the page break lines). This really cleared up the printing issue I was having entirely.Tue, 06 Mar 2012 11:34:39 GMTgrant-616287http://www.sqlservercentral.com/Forums/Topic1013196-391-1.aspxThis was my experience as well. I have battled with this printing issue for so long I have more or less given up on trying to print an ER diagram from SSMS. I've arranged my tables whilst showing the page breaks, but as previously stated, once you clicked "Print" all of your timely work was tossed out because SSMS thought it could do a better job. Kurt ZimmermanTue, 06 Mar 2012 10:41:40 GMTKurt W. Zimmermanhttp://www.sqlservercentral.com/Forums/Topic1013196-391-1.aspxThanks Ashraf for your post. I looked at it and while it is helpful in its suggestion to turn on the "view page breaks" feature of SQL Enterprise Mgr / SQL Management Studio Diagrams, it doesn't address what my problem was.On page 1 of the thread is where I placed my original question.To summarize, the problem wasn't with viewing the page breaks. I had this turned on just fine and had aligned my tables precisely within the page break boundaries. See this BEFORE screen capture to see how the diagram looked: http://www.sqlservercentral.com/Forums/Attachment9866.aspx.When attempting to PRINT this diagram though, all of the tables would shift so that they were no longer lined up the way I had placed them in the diagram. Here is what would happen as soon as I chose to PRINT the diagram: http://www.sqlservercentral.com/Forums/Attachment9867.aspxYou will notice, in the AFTER screen shot that all of the entities in the diagram have shifted down about 1/2 of a page so that they are now crossing the page break boundaries.Jeff Moden responded to my question shortly after posting to tell me to that I needed to place one of my entities closer to the bottom edge -- as SQL Management Studio was (un-helpfully) trying to center my diagram before printing. [i]By moving some of the entities so that they were NEAR the top boundary AND NEAR the bottom page break boundry [/i]-- the diagram would then print properly.Tue, 06 Mar 2012 10:31:17 GMTgrant-616287http://www.sqlservercentral.com/Forums/Topic1013196-391-1.aspxrefer this and all your problems would be taken care of.http://secretgeek.net/sql_ent_page.aspTue, 06 Mar 2012 10:19:48 GMTAsh DBAhttp://www.sqlservercentral.com/Forums/Topic1013196-391-1.aspxYou bet, Grant. Thank you for taking the time to post some feedback. :-)Fri, 30 Sep 2011 16:58:04 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1013196-391-1.aspxJeff,Thank you for your post, [u]it works perfectly[/u]. Now that I understand that it is trying to center the diagram I can control what it is doing. I moved some of the entities around on my diagram so that there was roughly the same whitespace in the top margin as in the bottom margin (in the bottom pages) and this took care of the problem. Going forward, I'll be able to follow this pattern and prevent this annoyance from cropping up in the future. Thank you very much for pointing this out!I've attached a screen shot of the entities moved around so that things are aligned in such a way that printing doesn't mess up my diagram. Thank you again.Sincerely,GrantThu, 29 Sep 2011 20:31:33 GMTgrant-616287http://www.sqlservercentral.com/Forums/Topic1013196-391-1.aspxMy work-around is,Zoom to 100%right-click on the diagramselect "Copy Diagram to Clipboard"Paste into MS Word or similarPrint it from there.If the diagram needs to span multiple pages I've also tried pasting into Excel so I can set the page breaks.Wed, 28 Sep 2011 09:39:38 GMTpaul.joneshttp://www.sqlservercentral.com/Forums/Topic1013196-391-1.aspxAre you going into File / Page Setup to set the correct paper size while you're using the diagram?I've had my page breaks move when previewing them using my default "Letter" size & then selecting 11 x 17 in the printer preferences when actually printing.My apologies if you're well past this point.Mon, 26 Sep 2011 07:54:10 GMTMike Bourgeoishttp://www.sqlservercentral.com/Forums/Topic1013196-391-1.aspxIt's certainly not a fix but there IS a work around...The "problem" is that the printed version treats all 6 pages as if it were a "single page" and tries to center the entire diagram on that "single page". The work around is to put one item close to the top of that "single page" and one item near the bottom. It doesn't even have to be anything significant... a sparsley filled text box with the date and the author's name (you DO do such things, don't you? ;-)) wil suffice.Sun, 25 Sep 2011 20:21:03 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1013196-391-1.aspxI appreciate you submitting a bug to Microsoft on this issue. I hope you will post anything you find back to this forum as I too am suffering from this problem.I have been having this problem for well over a year and it is beyond annoying. I am very diligent in how I put my database diagrams together, and I refer to them regularly throughout the software development process.I've attached a BEFORE and AFTER jpg so that it is completely clear to anyone what is happening. In the BEFORE screen shot, you can see the entities all carefully placed within the page breaks. In the AFTER screen shot, all I have done is choose to PRINT the diagram. You can see the print dialog box open in this screen shot, and you can also see how ALL of the entities have mysteriously shifted down by about 1/2 a page.I've tried to "outsmart" the shift, thinking OK, if it wants to shift 1/2 a page, I'll choose PRINT a 2nd time to see if it will shift again. Problem now is that it doesn't shift anymore. It stays "perfectly" misaligned. Sun, 25 Sep 2011 19:22:05 GMTgrant-616287http://www.sqlservercentral.com/Forums/Topic1013196-391-1.aspxYou have to admit that is so lame.... FYI I've posted this bug on the Microsoft support website. Thanks for your suggestion.KurtSat, 30 Oct 2010 06:02:21 GMTKurt W. Zimmermanhttp://www.sqlservercentral.com/Forums/Topic1013196-391-1.aspxSet zoom to visible level (75%-100%). Database Diagram menu, copy diagram to clipboard.MSPaint - Paste - Print.Perfect? No. But it works.Fri, 29 Oct 2010 16:03:52 GMTEvil Kraig Fhttp://www.sqlservercentral.com/Forums/Topic1013196-391-1.aspxI guess quest software have some toddler beta free tool?Check it outFri, 29 Oct 2010 14:17:46 GMT@SQLFRNDZhttp://www.sqlservercentral.com/Forums/Topic1013196-391-1.aspxYes, in fact I tried everything. What I noticed is when I simply go to print the page breaks shift (or maybe the entities move to the to the center of the diagram.Unfortunately budgets are tight to purchase a 3rd party tool like ERWin. Any open source solutions you can suggest? KurtFri, 29 Oct 2010 10:38:12 GMTKurt W. Zimmermanhttp://www.sqlservercentral.com/Forums/Topic1013196-391-1.aspxDid you set the database diagram to preview the page breaks so that you could see if they overlay page breaks? (Right-click on the back ground and click view page breaks)You would probably be better off with a third-pary tool for the diagrams if this is very important to you.Fri, 29 Oct 2010 10:17:43 GMTMichael Valentine Joneshttp://www.sqlservercentral.com/Forums/Topic1013196-391-1.aspxGreetings all; I have seen this issue/problem for a number of releases now and I have not been able to resolve it. I will admit I may be missing something here. When I design a database I typically create subject area database diagrams. Something I've done for quite some time and is essential when designing complex data structures. The problem that I have is printing the diagrams. I will spend a fair amount of time to insure I have my tables lined up and not overlapping the page. However when I go to print my entire ER diagram will shift causing tables to overlap pages. This is so annoying! 1) Has anyone else experience this? 2) Does anyone have a resolution for this? 3) Is there something that I'm doing wrong? or is this a known issue?Thanks in advance.KurtFri, 29 Oct 2010 10:08:29 GMTKurt W. Zimmerman