title: Convert column nText to nvarchar(1026)
body: <p>I need to change my column datatype from <code>nText null</code> to <code>nvarchar(1026) null</code>.
  I have used the below query(Sql server).</p>
  
  <pre><code>ALTER TABLE [Tablename] ALTER COLUMN [Columnname] nvarchar(1026) null
  </code></pre>
  
  <p>while executing the query, I am getting the following issue:</p>
  
  <blockquote>
    <p>Cannot alter column of type NTEXT or IMAGE [ Column Name = Columnname]</p>
  </blockquote>
  
  <p>Any help would be appreciated ! Thanks in advance :)</p>