SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Show Full Column Names on Results to Grid
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rythn
Starting Member

2 Posts

Posted - 09/22/2012 :  11:07:05  Show Profile  Reply with Quote
Hey everybody,

I'm having a problem with SQL Server Management Studio, as you can see below in the image, columns 1-3 are not showing the full column names. This happens when I right-click table name, and then click "Select Top 1000 Rows". I want it to show full column names.



Please help me out, Thanks.

tkizer
Almighty SQL Goddess

USA
36942 Posts

Posted - 09/22/2012 :  11:32:03  Show Profile  Visit tkizer's Homepage  Reply with Quote
Don't use that option to run your queries. Click the new query button and type in your query, then hit execute or F5. To expand them automatically, you can view them in text mode. But that'll cause other issues like some will be too big. I typically start in grid mode and switch to text mode as needed. And if text mode is needed and I need to shrink it down, I then add some converts to the varchar columns to get them to the minimum size.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

rythn
Starting Member

2 Posts

Posted - 09/22/2012 :  11:54:39  Show Profile  Reply with Quote
Unfortunately, the same problem happens in grid mode if I click the "new query" button and then execute a stored procedure / select statement. Text mode doesn't cut it for me, as it's harder to determine in which row is which value, since it doesn't have the borders. Thanks for your answer, but oh well, I guess I'l have to get used to seeing half column names.

quote:
Originally posted by tkizer

Don't use that option to run your queries. Click the new query button and type in your query, then hit execute or F5. To expand them automatically, you can view them in text mode. But that'll cause other issues like some will be too big. I typically start in grid mode and switch to text mode as needed. And if text mode is needed and I need to shrink it down, I then add some converts to the varchar columns to get them to the minimum size.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 09/22/2012 :  12:46:39  Show Profile  Reply with Quote
you can always resize them as you want if needed. or copy result using copy with column headers option and paste it on an excel to see full results

you may even choose save as file option and save query results directly in file and view it

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000