SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database Diagram printing problems


Database Diagram printing problems

Author
Message
grant-616287
grant-616287
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 22
Jeff,

Thank you for your post, it works perfectly. 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,
Grant
Attachments
solved.jpg (17 views, 123.00 KB)
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (218K reputation)SSC Guru (218K reputation)SSC Guru (218K reputation)SSC Guru (218K reputation)SSC Guru (218K reputation)SSC Guru (218K reputation)SSC Guru (218K reputation)SSC Guru (218K reputation)

Group: General Forum Members
Points: 218490 Visits: 41996
You bet, Grant. Thank you for taking the time to post some feedback. :-)

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Ash DBA
Ash DBA
Valued Member
Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)

Group: General Forum Members
Points: 66 Visits: 140
refer this and all your problems would be taken care of.

http://secretgeek.net/sql_ent_page.asp
grant-616287
grant-616287
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 22
Thanks 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.aspx

You 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. By moving some of the entities so that they were NEAR the top boundary AND NEAR the bottom page break boundry -- the diagram would then print properly.
Kurt W. Zimmerman
Kurt W. Zimmerman
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2652 Visits: 1400
This 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 Zimmerman

Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY

http://www.linkedin.com/in/kurtwzimmerman
grant-616287
grant-616287
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 22
Hey 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.
crapper_mail
crapper_mail
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 44
Surprised 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.
HH1233
HH1233
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 34
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 appreaciated.
HH1233
HH1233
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 34
HH-489628 (3/25/2013)
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.
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search