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 |
|
crichardson
Starting Member
6 Posts |
 Posted - 2006-03-02 : 08:40:47
|
| I have some code that generates XML and inserts it into a text field in a table. The datalength of the text in the field can vary but the problem shows itself with long datalengths greater than 4104. If I run the code from QA, it produces the expected results that I can verify by running...select datalength(textfield) from myTbloutput:- 35123However, if I run exactly the same code from within a job, it truncates the long XML 'strings' to 4104.Any suggestions?Clive |
|
|
crichardson
Starting Member
6 Posts |
Posted - 2006-03-02 : 09:54:54
|
| Ok, I have narrowed the problem down a bit. If the text field is populated directly by a select from another table, it works in QA and in a JOB. However, if the text field is populated by a stored proc like..insert into MyTbl exec spGetXMLThe above does not truncate the text field in QA but it does truncate the text file in MyTbl if the code is run from a job. The same basic query is involved in both cases but in the second case it is just wrapped in a sproc.Any thoughts?Clive |
 |
|
|
crichardson
Starting Member
6 Posts |
Posted - 2006-03-02 : 10:49:11
|
| More... I can not replicated this problem on other servers. No idea what's causing this behavior though.Clive |
|
|
|
|
|
|
text data truncated in text field - only in job