SQL 2005 Query result to Grid: column header names are truncated

Question

SQL 2005 Query result to Grid: column header names are truncated

wb640

Mr or Mrs. 500

Points: 538
More actions
April 11, 2008 at 4:28 am

#189015

When I execute any query in SQL 2005 Query Window, the Grid result set truncates the column headers (field names). Is there any way to show always full column names above the columns ?
Sample output:
http://img.photobucket.com/albums/v249/wb640/sql2005result.jpg
Thanks,
wb640

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 1

I don't think there is.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

wb640 Mr or Mrs. 500 Points: 538 More actions · Answer 2

Grant Fritchey (4/11/2008)
I don't think there is.

Thanks for the reply, but I keep hoping .... 🙂

Robert-378556 SSCertifiable Points: 5917 More actions · Answer 3

They're truncated visually as it sizes column based on data size. You can always enlarge the column to see full column names.

wb640 Mr or Mrs. 500 Points: 538 More actions · Answer 4

Robert (4/11/2008)
They're truncated visually as it sizes column based on data size. You can always enlarge the column to see full column names.

Yep, I know. But that's too much work (as you can see from the printscreen). Only workaround now is to set output to Text instead of Grid, there the full column name is shown. But as far as I can remember, in SQL 2000 the full column name was shown with output to grid ...

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 5

It doesn't answer the question, but you can double click on the line next to the column and it will expand to the full size for you. A tiny bit of help.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

wb640 Mr or Mrs. 500 Points: 538 More actions · Answer 6

Grant Fritchey (4/11/2008)
It doesn't answer the question, but you can double click on the line next to the column and it will expand to the full size for you. A tiny bit of help.

I tried that (thinking the Excel way) but that actually doesn't work in my SQL2005 environment ! The cursor does change to the column marker, but double-clicking doesn't do anything.

I'm using SQL2005 Developer Edition:

Microsoft SQL Server Management Studio9.00.3042.00

Microsoft Analysis Services Client Tools2005.090.3042.00

Microsoft Data Access Components (MDAC)6.0.6000.16386 (vista_rtm.061101-2205)

Microsoft MSXML3.0 4.0 5.0 6.0

Microsoft Internet Explorer 7.0.6000.16643

Microsoft .NET Framework2.0.50727.312

Operating System6.0.6000 (Vista.. yep)

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 7

Hmmm. Same version. Maybe it only works for the data in the column.... Nope. It's working for me. I wonder what's up with that.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

wb640 Mr or Mrs. 500 Points: 538 More actions · Answer 8

Mmm ... I think I solved this myself now. And I am the one to blame ...:Whistling:

I executed the same query from another PC/SQL2005 Manager, and there the column names were not truncated, and also doubleclicking on the column seperators worked.

The difference: in my own environment, I changed the FONT for the Grid result to 'Lucida console' 8 pt some time ago, to see the result in a non-proportional font. But when using this, the column names are truncated and double-clicking on the column seperators won't work.

So I changed the font back to Microsoft Sans Serif 8pt and all is well ... 😛

Thanks guys, for thinking with me !