How do I increase the SSMS grid font size

There are options to change fonts for the Editor tab, but I have yet
to find how to change the results tab font.
If it cannot be done in in 2005, at least let it be done in 2008.
IanO
Just to add to Tibor's response that most of the settings require you to
close SSMS before they take effect. I don't remember if this is one of them
or not.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:56F1AA88-63DD-4E52-96B8-7B43F73A7493@.microsoft.com...
> Tools, Options, Environment, Fonts and Colors, Show Settings for:
> Grid Results
> Text Results
> Are you saying that above doesn't work?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "IanO" <IanONet@.gmail.com> wrote in message
> news:8ce30204-4e4e-497e-92c7-01f6cd9ac432@.i12g2000prf.googlegroups.com...
>

How do I increase the SSMS grid font size

There are options to change fonts for the Editor tab, but I have yet
to find how to change the results tab font.
If it cannot be done in in 2005, at least let it be done in 2008.
IanOTools, Options, Environment, Fonts and Colors, Show Settings for:
Grid Results
Text Results
Are you saying that above doesn't work?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"IanO" <IanONet@.gmail.com> wrote in message
news:8ce30204-4e4e-497e-92c7-01f6cd9ac432@.i12g2000prf.googlegroups.com...
> There are options to change fonts for the Editor tab, but I have yet
> to find how to change the results tab font.
> If it cannot be done in in 2005, at least let it be done in 2008.
> IanO|||Just to add to Tibor's response that most of the settings require you to
close SSMS before they take effect. I don't remember if this is one of them
or not.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:56F1AA88-63DD-4E52-96B8-7B43F73A7493@.microsoft.com...
> Tools, Options, Environment, Fonts and Colors, Show Settings for:
> Grid Results
> Text Results
> Are you saying that above doesn't work?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "IanO" <IanONet@.gmail.com> wrote in message
> news:8ce30204-4e4e-497e-92c7-01f6cd9ac432@.i12g2000prf.googlegroups.com...
>> There are options to change fonts for the Editor tab, but I have yet
>> to find how to change the results tab font.
>> If it cannot be done in in 2005, at least let it be done in 2008.
>> IanO
>|||> I don't remember if this is one of them or not.
Yes, it is (I tested it yesterday). SSMS tell you that pretty clearly, though. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eheiZRBdIHA.4936@.TK2MSFTNGP03.phx.gbl...
> Just to add to Tibor's response that most of the settings require you to close SSMS before they
> take effect. I don't remember if this is one of them or not.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:56F1AA88-63DD-4E52-96B8-7B43F73A7493@.microsoft.com...
>> Tools, Options, Environment, Fonts and Colors, Show Settings for:
>> Grid Results
>> Text Results
>> Are you saying that above doesn't work?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "IanO" <IanONet@.gmail.com> wrote in message
>> news:8ce30204-4e4e-497e-92c7-01f6cd9ac432@.i12g2000prf.googlegroups.com...
>> There are options to change fonts for the Editor tab, but I have yet
>> to find how to change the results tab font.
>> If it cannot be done in in 2005, at least let it be done in 2008.
>> IanO
>

How do I get a list of tables in T-SQL

Hi,
Is there anything equivalent to Oracle'sSelect * from tab in MS SQL.I have got the answer

select name from sysobjects where type = 'U'

|||That will work, but try one of these 2 alternate methods to assure forward-compaitbility with future SQL Server versions:

EXEC sp_table
SELECT * FROM INFORMATION_SCHEMA.TABLES

Note that each of the 3 options yields slightly different results as they filter the information differently. Generally sys* tables should not be queried directly as they are subject to chage.

Terri

How do i do this with dts

Im using DTS to a basic import of a products csv into a corresponding table in sql server. I use the transformations tab to map up all the fields between the two. I have one field in the sql server table that I need to include a value everytime the dts is run. So for eg one of the fields in the sql table is ProductTypeCode and in this case it should always be 1. Now as a cheap and dirty workaround I could add another column in my csv and give all the fields values of 1 and map that column to my ProductTypeCode in sql server table but surely there a more correct way of doing this simple task.

Thanks in advanceYou can create a query for the source, using the Excel table, you can add a 1 to that query. So when you set up the source, use a query, then use the query builder to setup the initial design from the excel file. Then modify the resulting query to add the 1 parameter.

Brian|||Try this url for all your DTS questions most problems are covered here, it is run by Darren Green a SQL Server MVP.
http://www.sqldts.com Hope this helps.

Kind regards,
Gift Peddie

How do I display lables outside Chart area of a Pie Chart

How do I display the labels outside of the chart area of a pie chart? The
Point Labels properties tab of the Chart Value does not show a setting to
display labels outside of the chart area. Am I missing something?
PPNote: you will need SP1 installed for this to work. The SP1 readme contains
a section about outside labels in pie charts:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_chart_enhancements
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"B. Mark McKinney" <BMarkMcKinney@.discussions.microsoft.com> wrote in
message news:D2C14B13-3314-4553-AF82-41039BFE60F2@.microsoft.com...
> On the Point Labels tab uncheck the Auto checkbox n the Position secition.
> "msnews.microsoft.com" wrote:
> > How do I display the labels outside of the chart area of a pie chart?
The
> > Point Labels properties tab of the Chart Value does not show a setting
to
> > display labels outside of the chart area. Am I missing something?
> >
> > PP
> >
> >
> >