title: Change NTEXT Data Type to Fit More Data
body: <p>One of my coworkers is using SQL Server 2000 and is having a display issue where an XML column using data type <code>ntext</code> is displaying <code>&lt;Long Text&gt;</code>. I'm guessing that's because the character length is too short <code>(16)</code>, but it will not allow any changes.</p>
  
  <p>When trying to alter the data type to <code>varchar</code> a warning appears. Will changing the datatype from <code>ntext</code> to <code>varchar/nvarchar</code> affect the data in the table?</p>