title: Large XML Files in SSMS
body: <p>I tried to import a big XML File in SSMS,
  but I encounter this problem.</p>
  
  <blockquote>
    <p>'INSXMLII.XML' is too large to open with XML editor. The maximum file
    size is '10' MB. Please update the registry key
    'HKCU\Software\Microsoft\SQL Server Management
    Studio\18.0_IsoShell_Config\XmlEditor\MaxFileSizeSupportedByLanguageService'
    to change the maximum size.</p>
  </blockquote>
  
  <p>I used method to fix:
  Navigate to:</p>
  
  <blockquote>
    <p>"C:\Program Files (x86)\Microsoft SQL Server Management Studio
    18\Common7\IDE"</p>
  </blockquote>
  
  <p>Edit the "Microsoft.XmlEditor.pkgdef" file at approximately line number 322:</p>
  
  <p>Change the line:</p>
  
  <blockquote>
    <p>"MaxFileSizeSupportedByLanguageService"="10"</p>
  </blockquote>
  
  <p>To:</p>
  
  <blockquote>
    <p>"MaxFileSizeSupportedByLanguageService"="99999999999"</p>
  </blockquote>
  
  <p>Restart SSMS.</p>
  
  <p>However, it encountered this problem:</p>
  
  <blockquote>
    <p>"Access to the path C:\Program Files (x86)\Microsoft SQL Server
    Management Studio
    18\Common7\IDE\CommonExtensions\Platform\Shell\Microsoft.XmlEditor.pkgdef"</p>
  </blockquote>
  
  <p>Any thoughts? I have totally no ideas~
  Many thanks</p>