Geeks With Blogs
Eron Wright - All Killer No Filler blog

If you work with SQL Server 2000 and FOR XML functionality, you curse Query Analyzer probably as often as I do.  Here are some tips for improving the output:

  1. In QA, set “Maximum Characters per Column” setting to 2033
  2. Execute DBCC TRACEON(257) to pretty-print the XML output

http://www.winnetmag.com/SQLServer/Article/ArticleID/20698/20698.html

Posted on Wednesday, September 15, 2004 2:40 PM Technology | Back to top


Comments on this post: Working with Query Analyzer and FOR XML

# re: Working with Query Analyzer and FOR XML
Requesting Gravatar...
why only 2033 and not the max of 8192?
Left by Colin Bendell on Sep 17, 2004 11:57 AM

# re: Working with Query Analyzer and FOR XML
Requesting Gravatar...
I guess I should have said "at least 2033".
Left by Eron Wright on Sep 17, 2004 12:07 PM

# re: Working with Query Analyzer and FOR XML
Requesting Gravatar...
hey, that was very simple and extremely helpful!!

thanks!

Left by Matheus Guimaraes on Dec 08, 2004 8:55 AM

Your comment:
 (will show your gravatar)


Copyright © Eron Wright | Powered by: GeeksWithBlogs.net