Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bex
Aged Yak Warrior
580 Posts |
 Posted - 2006-04-24 : 10:12:47
|
| Hello allI am trying to extract data into xml format, using FOR XML. I have executed the query outputting in text, grid and saved to a file. The output is not nicely formatted, but when I manually format it, chunks of data is missing as the rows in the output are truncated. Any ideas?Hearty head pats |
|
|
RyanRandall
Master Smack Fu Yak Hacker
1074 Posts |
Posted - 2006-04-24 : 11:47:03
|
| Hi Bex,Just a guess, but could this be related to 'Tools/Options/Results/Maximum characters per column' in Query Analyzer? Is that set to the max of 8000 for you?Ryan Randallwww.monsoonmalabar.com London-based IT consultancy Solutions are easy. Understanding the problem, now, that's the hard part. |
 |
|
|
Bex
Aged Yak Warrior
580 Posts |
Posted - 2006-04-24 : 12:31:00
|
Ah ha! brilliant! you are so right! Thankyou Ryan. I am so glad that there is a simple solution for a change!  Hearty head pats |
|
|
|
|
|
|
Truncate xml results issue