In query analyser, how to expand row length in result pane?

microsoft.public.sqlserver.tools

19 Jan 2007 9:04 PM

Iter

Hi guys,
I have statement which I need to get result that includes long result. So
the row was truncate and cannot display the entire row. How can expand the
row length in the result pane? Thanks.

19 Jan 2007 9:42 PM

Simon Sabin

Hello Iter,

Select Tools|options select the results tab and increase the value in "Maximum
characters per column"

Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

Show quote

> Hi guys,
> I have statement which I need to get result that includes long result.
> So
> the row was truncate and cannot display the entire row. How can expand
> the
> row length in the result pane? Thanks.

19 Jan 2007 10:07 PM

Iter

It is worked. Thanks.

Show quote

"Simon Sabin" wrote:

> Hello Iter,
>
> Select Tools|options select the results tab and increase the value in "Maximum
> characters per column"
>
> Simon Sabin
> SQL Server MVP
> http://sqlblogcasts.com/blogs/simons
>
>
> > Hi guys,
> > I have statement which I need to get result that includes long result.
> > So
> > the row was truncate and cannot display the entire row. How can expand
> > the
> > row length in the result pane? Thanks.
>
>
>