Home All Groups Group Topic Archive Search About

Upgrading Database Diagrams to 2005

Author
14 Mar 2006 5:38 PM
Kevin
I upgraded from Sql Server 2K to 2005 and in the process upgraded the
database diagrams.  When I view the upgraded database diagram the font size
and row height of the tables have increased so the bottom 25% of the rows
don't display.

Is there a way to control the font size of the tables so I don't have to
edit the entire 100 table diagram.

Regards,
Kevin

Author
14 Mar 2006 11:40 PM
Gail Erickson [MS]
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights

Show quote
"Kevin" <Ke***@discussions.microsoft.com> wrote in message
news:BC69A0C8-2E33-4DA1-8D21-096FD9BF4F53@microsoft.com...
>I upgraded from Sql Server 2K to 2005 and in the process upgraded the
> database diagrams.  When I view the upgraded database diagram the font
> size
> and row height of the tables have increased so the bottom 25% of the rows
> don't display.
>
> Is there a way to control the font size of the tables so I don't have to
> edit the entire 100 table diagram.
>
> Regards,
> Kevin
Author
14 Mar 2006 11:42 PM
Gail Erickson [MS]
Hi Kevin,

You can modify the font size of the database diagrams by following these
instructions.
1.  From SQL Server Management Studio, from the toolbar, click Tools and
then click Options.
2.  From the Options page, expand Environment, and then select Fonts and
Colors.
3.  From Show Settings for:, select Table and Database Designers
4.  Adjust the font style and size as needed.

The change in font/size will be applied to any existing diagrams and any new
diagrams you create. That is, you can't set different font sizes for
individual diagrams.

I apologize for not including this information in Books Online. It appears
the topic that contained this information was inadvertently left out. I'll
add this topic in the next update of Books Online (currently scheduled for
April 2006).

Regards,
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights

Show quote
"Kevin" <Ke***@discussions.microsoft.com> wrote in message
news:BC69A0C8-2E33-4DA1-8D21-096FD9BF4F53@microsoft.com...
>I upgraded from Sql Server 2K to 2005 and in the process upgraded the
> database diagrams.  When I view the upgraded database diagram the font
> size
> and row height of the tables have increased so the bottom 25% of the rows
> don't display.
>
> Is there a way to control the font size of the tables so I don't have to
> edit the entire 100 table diagram.
>
> Regards,
> Kevin
Author
15 Mar 2006 9:16 PM
Kevin
Thanks Gail,

That works.

Kevin

Show quote
"Gail Erickson [MS]" wrote:

> Hi Kevin,
>
> You can modify the font size of the database diagrams by following these
> instructions.
> 1.  From SQL Server Management Studio, from the toolbar, click Tools and
> then click Options.
> 2.  From the Options page, expand Environment, and then select Fonts and
> Colors.
> 3.  From Show Settings for:, select Table and Database Designers
> 4.  Adjust the font style and size as needed.
>
> The change in font/size will be applied to any existing diagrams and any new
> diagrams you create. That is, you can't set different font sizes for
> individual diagrams.
>
> I apologize for not including this information in Books Online. It appears
> the topic that contained this information was inadvertently left out. I'll
> add this topic in the next update of Books Online (currently scheduled for
> April 2006).
>
> Regards,
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
>
> "Kevin" <Ke***@discussions.microsoft.com> wrote in message
> news:BC69A0C8-2E33-4DA1-8D21-096FD9BF4F53@microsoft.com...
> >I upgraded from Sql Server 2K to 2005 and in the process upgraded the
> > database diagrams.  When I view the upgraded database diagram the font
> > size
> > and row height of the tables have increased so the bottom 25% of the rows
> > don't display.
> >
> > Is there a way to control the font size of the tables so I don't have to
> > edit the entire 100 table diagram.
> >
> > Regards,
> > Kevin
>
>
>

AddThis Social Bookmark Button