SQL Server 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