Upgrading Database Diagrams to 2005

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

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

"Kevin" <Kevin@discussions.microsoft.com> wrote in message
news:BC69A0C8-2E33-4DA1-8D21- 096FD9BF4F53@microso
ft.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

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" <Kevin@discussions.microsoft.com> wrote in message
news:BC69A0C8-2E33-4DA1-8D21- 096FD9BF4F53@microso
ft.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

Thanks Gail,

That works.

Kevin

"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 n
ew
> 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" <Kevin@discussions.microsoft.com> wrote in message
> news:BC69A0C8-2E33-4DA1-8D21- 096FD9BF4F53@microso
ft.com... 
>
>
>