SQL 2005 Column Width

Posted on 2011-05-07
Medium Priority
Last Modified: 2012-05-11
when you right click on a table name in SQL and select open, if the column titles are too long to display completely, SQL adds ... on the end of the column name.  Is there a way to tell SQL to widen all the columns wide enough to display the complete column name?  
I am not referring to widening the column width to the data in the rows but the column name.
Question by:dastaub
LVL 57

Accepted Solution

Raja Jegan R earned 1000 total points
ID: 35713108
Just double click on the column name in Designer window so that it would expand to fit entire column name..
Since this is something related to GUI, there is no default settings that can be done for this.

Author Comment

ID: 35713158
once the column has been expaned, can it be saved that way.
LVL 25

Assisted Solution

by:DBAduck - Ben Miller
DBAduck - Ben Miller earned 1000 total points
ID: 35713863
No it doesn't work that way for that operation.  There would be way too much context to keep for every right-click open operation performed.

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question