athea123
asked on
T-SQL adding control characters to NTEXT field
Hi, I'm modifying the reportserver catalog table parameter field which is NTEXT using a stored procedure. I'm reading in the original ntext parameter field and converting it's value from ntext to XML to manipulate specific elements and change their values. That is working fine. I'm writing the changed parameter value back to catalog.parameter converting it back to NTEXT. I noticed because I converted it to XML it loses all of the control characters (tabs, carriage returns ? which were stored originally in the NTEXT value. I think when I then try to run Report Manager with my new parameter value, it's failing because I need the control characters. I'm attaching a file to show the parameter field before and after. Can someone tell me if there is an easy way to fix this? THank You!
20110215ParameterFieldWithandWit.doc
20110215ParameterFieldWithandWit.doc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER