I have a stored procedure that saves 4 fields into a data table named xml. One of the fields is called xml, and is just a text field. Usually, my sp properly stores the data, but occassionally the xml portion of my record is not stored. It's on a remote server, so I'm having trouble hooking up a debugger to it, but I may have identified some charactoristics of the data in the cases where the data is not saving into the field. I think it has a lot of "......."s mixed in with the xml. I'm wondering if SQL could be identifying this as some kind of security threat. Any thoughts would be super appreciated.
View Complete Post