title: Convert computed column to regular column
body: <p>I have a persisted computed column in a large table in in SQL Server 2005.</p>
  
  <p>I want to convert it to a regular column, keeping current values.</p>
  
  <p>Do I have to recreate the column and update the entire table in transaction,
  or is it possible to just alter a computed column specification, and how to do it?</p>