Increase the number of characters retrieved from the server for XML data In SQL Server
15:59
At first, from Sql Server Management Studio click on Tools > Options
Go to Query Results > SQL Server > Results to Grid > XML Data. By defaults it was set to 2 MB. Please set it to Unlimited.
0 comments