title: Change the data type of a table column in SQL Server 2008
body: <p>I need to change the data type of a column from nvarchar(50) to nvarchar(MAX).  The problem is I already have data in hundreds of rows in this table and I don't want to lose the data.</p>
  
  <p>Is there anyway to change the data type of a column without losing the data in that column?</p>