Weird results when printing a diagram in SQL Server 2005

Hi all,

I have a diagram that I'm trying to print. I'm getting a weird result on paper.

I have 3 tables on the same paper. I use the standard view mode in order to see "column name", "condensed type" and "nullable" columns. When the print comes out, the first 5 rows of the "column name" column are masked by some sort of drawing. It's as if there was another table on top of the one I'm printing, like you can see the bottom right corner of it just hiding the 5 rows of the "column name" column. What is even more weird is that have the exact same problem on the 3 tables I'm printing.

This "drawing" appears to be of fixed size because as I increase the width of the first column, the width of the drawing doesn't increase, so if the width of the first column is very small, the drawing goes also on top of the next colum "condensed type."

Now, if I increase the height of the table and allow white space between the last row and the table border, I also get almost the same drawing in the white space. But this time, it's only as if the right side of this mysterious "table" that appears (no corners.)

I'm sorry for all this explanation but I cannot describe it better than that.

Does anybody know if there is a fix to this problem. I'm getting the exact same results from SQL Server Management Studio and from inside Visual Studio 2005. I have SP1 for SQL Server Tool and Workstation components 2005 ENU (KB913090) installed, as well as SP1 for SQL Server Database Services 2005 ENU (KB913090.)

Thanks,
Talal

[1658 byte] By [talalsultan] at [2007-12-24]
# 1

export the diagram to ms visio.

hahaha

joeydj at 2007-8-31 > top of Msdn Tech,SQL Server,SQL Server Tools General...
# 2
I got the same problem here. Need help
hzha034 at 2007-8-31 > top of Msdn Tech,SQL Server,SQL Server Tools General...
# 3
I have the same problem. While this is not a solution my only work around has been to right click and save the diagram to the clipboard, Paste it elsewhere and than print.
HeatherS2006 at 2007-8-31 > top of Msdn Tech,SQL Server,SQL Server Tools General...
# 4

I'm having this same issue - printing database diagrams results in extraneous squares being printed, typically in the upper left corner of tables and covering 5 rows. Occurs against multiple database servers, from multiple clients, and printing on a variety of printers.

This creates real issues as to the usability of database diagrams created in SQL Server 2005. I've seen this issue mentioned in NNTP newsgroups as well. Has anyone seen a response from Microsoft?

RonStrong at 2007-8-31 > top of Msdn Tech,SQL Server,SQL Server Tools General...
# 5

***Bump***

I'm having this same problem.

Here's my procedure to recreate this problem:

Create a new diagram.
Add tables to diagram.
Save the diagram.
Print the diagram.

Prints just fine.

Close SQL Server Mgt Studio.
Re-Open SQL Server Mgt Studio.
Change something in the diagram (location of any table would do.)
Save the diagram.
Print the diagram.

Prints with the top five column names masked with a dual-shaded square. I've tried with different table views, Standard, Column Names, Custom, etc...
Anyone have a fix for this?

Thanks!

JonathanMacCollum at 2007-8-31 > top of Msdn Tech,SQL Server,SQL Server Tools General...

SQL Server

Site Classified