SQL Server truncating XML return value -
i'm debugging existing sproc in our organization. it's trying return xml string (using "for xml auto") 2047 bytes long.
when run sproc in ssms, return value appears in results window. if click on value (shown hyperlink), new window opens , displays whole string. (by way, string single xml element data contained in attributes. not design, that's i'm working with.)
if, however, view result in results pane (by dragging out width of column), last few bytes truncated. see 2034 characters.
as it's 2034 characters, it's not limit of ssms results window (2mb default, set unlimited). exact same string gets sent service calling sproc (via ado.net , executescalar).
why sproc truncating xml?
thanks, jay
a co-worker found microsoft kb article entitled the xml data row truncated @ 2,033 characters when use sqldatareader object provides solution (use executexmlreader
instead):
Comments
Post a Comment