"Aaron Bertrand [SQL Server MVP]" wrote:

> > 1. How can I get the data to wrap in a cell? If it is long, it just shows
> > part of the data with '...' at the end.
>
> You can't; it eliminates carriage returns.  It wouldn't be a very good grid
> if you had to scroll 80 times to see the next row.
>
> > 2. When I drag to increase the height of a row, if only increase the
> > height
> > for that one row. How can I increase the height for all rows?
>
> I don't know that you can.  It's not exactly Excel.
>
>
>
>

"Erland Sommarskog" wrote:

> JoJo3 (Jo***@discussions.microsoft.com) writes:
> > It may not be Excel but I would think the Enterprise Manager
> > functionality would be carried over to Management Studio and not
> > removed. I cannot see all the data in a results cell. Even the tool tip
> > on it ends with '...'. It's useless without being able to see all the
> > complete value on a column in the cell.
>
> You can double-click the splitter between the columns and the column
> will be extended to the width needed to show the full value.
>
> On http://connect.microsogt.com you can submit suggestions for improvements
> for Mgmt Studio. You may want to search for similar suggestions. You
> are probably not the first to ask for this.
>
> Also, make it clear what you are talking about. Your post talk about
> grid results, but then you said:
>
>   2. When I drag to increase the height of a row, if only increase the 
>   height for that one row. How can I increase the height for all rows?
>
> This is not possible in the result grid results, but well in Open Table,
> and I would assume the in the grid results for the Query Designer.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>

"JoJo3" wrote:
> Hi - I have 2 questions concerning the grid query results in Management
> Studio:
>
> 1. How can I get the data to wrap in a cell? If it is long, it just shows
> part of the data with '...' at the end.
>
> 2. When I drag to increase the height of a row, if only increase the
> height
> for that one row. How can I increase the height for all rows?
>
> These things worked well in Netrprise Manager.
>
> Thanks.