Set Option 'XML data' via script

• msa 52486

  SSC Rookie

  Points: 26

  More actions

  July 20, 2017 at 5:31 am

  #343647

  Is there a possibility to script the setting in SSMS --> Options/Query Results/SQL Server/Results to Grid/Maximum Characters Retrieved/XML data
  to set it to unlimited?

  Best regards from Austria
  Martin

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738743

  More actions

  July 20, 2017 at 11:15 am

  #1951921

  I would guess there is. Either it's in your .vsssettings file or it's in the registry.