I have a stored procedure on SQL Server 2008 that returns an xml document.
It appears that the size of the xml is being truncated to 2Mb.
I have modified the max size of xml in Management Studio to unlimited but I still get the problem.
I wonder if there is some limitation on the size of the variable declared in the stored procedure, or the size of the result set?
Thanks for any advice.