Posted by Hugo Kornelis on 07/30/07 20:17

On Mon, 30 Jul 2007 07:51:41 -0700, Mo wrote:

>Hi,
>I am trying to generate an XML output form the database. I am
>executing
>
>select * from Request_vw for xml auto
>
>The output data is being truncated. is there a limit on the output
>result of an XML query?
>
>Thanks

Hi Mo,

In SQL Server Management Studio: Tools / Options / Query Results / SQL
Server / Results to Text / Maximum number of characters displayed in
each column

In Query Analyzer: Tools / Options / Results / Maximum characters per
column

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

• Next in forum: Re: Why XML Output is Truncated
• Prev in forum: Re: Pass Table as a parameter to a function
• Thread view: Re: Why XML Output is Truncated

[Reply to this message]