title: How to Alter Column from nvarchar(max) to nvarchar(50)
body: <p>I have an existing table in SQL SERVER 2008 with one of its column as NVARCHAR(MAX) and it only has values of less than 10 characters in it.
  This table is in production and has data in it.</p>
  
  <p>I have got a requirement wherein I have to Alter this column from NVARCHAR(MAX) to NVARCHAR(50). T<strong>he SQL Server gives some Truncation error while doing this operation</strong>, even though the data in that column is less than 10 characters.</p>
  
  <p>This is my script:</p>
  
  <pre><code>ALTER TABLE [dbo].[Table] ALTER COLUMN [Column1] NVARCHAR ( 50 ) NOT NULL 
  </code></pre>