title: SQL Server json truncated (even when using NVARCHAR(max) )
body: <pre><code>DECLARE @result NVARCHAR(max);
  
  SET @result = (SELECT * FROM table
                 FOR JSON AUTO, ROOT('Data'))
  
  SELECT @result;
  </code></pre>
  
  <p>This returns a json string of ~43000 characters, with some results truncated.</p>
  
  <pre><code>SET @result = (SELECT * FROM table
                 FOR JSON AUTO, ROOT('Data'))
  </code></pre>
  
  <p>This returns a json string of ~2000 characters. Is there any way to prevent any truncation? Even when dealing with some bigdata and the string is millions and millions of characters?</p>