Diagram changes

22 Jan 2007 4:25 PM

Terry Holland

There seem to be a number of annoying little problems with the diagram tool
in sql server 2005 (and previous versions) and Im not sure if these will be
fixed by installing SP1. The annoyances are

1) I arrange tables so that none of them have scroll bars, but when I print,
some of my tables have scroll-bars on the printed output.

2) In page setup, I set page to landscape. I then arrange my tables to fit
on a single landscape page, save and print. The diagram then rearranges
itself and I end up with multiple pages each containing a small part of the
diagram.

3) Page orentation is not 'remembered' resulting in me having to re-arrange
tables when I next open the diagram

These issues do not happen all the time but when they do it is very annoying.

Are there workarounds to these problems?

Will these 'bugs' get fixed by installing sp1?

@@Version = Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14
2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Developer
Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

22 Jan 2007 7:04 PM

Kevin3NF

For Item 1, I always had to drag the bottom of the table just a bit lower
than the bottom of the last field.

Can't help on 2 & 3

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com

Show quote

"Terry Holland" <MSDNNospam248@nospam.nospam> wrote in message
news:F5B57303-2098-40E2-8C3C-D12018FE94FE@microsoft.com...
> There seem to be a number of annoying little problems with the diagram
> tool
> in sql server 2005 (and previous versions) and Im not sure if these will
> be
> fixed by installing SP1. The annoyances are
>
> 1) I arrange tables so that none of them have scroll bars, but when I
> print,
> some of my tables have scroll-bars on the printed output.
>
> 2) In page setup, I set page to landscape. I then arrange my tables to
> fit
> on a single landscape page, save and print. The diagram then rearranges
> itself and I end up with multiple pages each containing a small part of
> the
> diagram.
>
> 3) Page orentation is not 'remembered' resulting in me having to
> re-arrange
> tables when I next open the diagram
>
> These issues do not happen all the time but when they do it is very
> annoying.
>
> Are there workarounds to these problems?
>
> Will these 'bugs' get fixed by installing sp1?
>
>
> @@Version = Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14
> 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Developer
> Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

23 Jan 2007 5:49 AM

Charles Wang[MSFT]

Hi,
For your three issues, I reproduced the first one. My SQL Server 2005 was
installed with SP1.

>1) I arrange tables so that none of them have scroll bars, but when I
print,
>some of my tables have scroll-bars on the printed output.

I tried four times to reproduce this issue. It seemed that the scroll bars
occurred when we ajusted the border closely to the last column.

>2) In page setup, I set page to landscape. I then arrange my tables to
fit
>on a single landscape page, save and print. The diagram then rearranges
>itself and I end up with multiple pages each containing a small part of
the
>diagram.

I set the orientation to landscape, save and print the diagram, but the
diagram did not rearrange.

>3) Page orentation is not 'remembered' resulting in me having to
re-arrange
>tables when I next open the diagram

From my test, the page orentation was remembered.

Also, I noticed that the issues rarely happened at your side, so I am not
sure if my test can prove that these issues had already been fixed in SP1.
If it persists, I recommend that you give Microsoft feedback on these
issues. Your suggestions will be routed to SQL team and the issues will be
resolved in the next release.
https://connect.microsoft.com/sql

If you are very concerned with this issue, I recommend that you contact
Microsoft Customer Support Services (CSS) via telephone so that a dedicated
Support Professional can assist you recover the server in a more efficient
manner. Please be advised that contacting phone support will be a charged
call.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.

Please feel free to let me know if you have any other questions or concerns.

Sincerely yours,
Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

25 Jan 2007 2:27 PM

Charles Wang[MSFT]

Hi,
Just check with you to see if this issue persists after your installing SQL
Server 2005 SP1.

Please feel free to let us know if you need further assistance.

Have a great day!

Sincerely yours,
Charles Wang
Microsoft Online Community Support