title: How to alter column nvarchar length without drop
body: <p>I'm trying to alter the length of the column &quot;Body&quot; in table &quot;Post&quot; like this:</p>
  <pre><code>ALTER TABLE Post ALTER COLUMN Body nvarchar(8000) NOT NULL;
  </code></pre>
  <p>The column is defined as nvarchar(4000) and it gives me this error:</p>
  <blockquote>
  <p>Msg 2717, Level 16, State 2, Line 1
  The size (8000) given to the parameter 'Body' exceeds the maximum allowed (4000).</p>
  </blockquote>