title: How to switch from VARCHAR to TEXT in SQL 2000?
body: <p>What do I need to consider before I switch a bunch of fields from VARCHAR(bignumber) to TEXT?</p>
  
  <p>Aside from performance, and sometime in the far future TEXT will be deprecated, and aside from the fact that it looks like I need to drop and recreate the table to alter the column's data type?</p>
  
  <p>This is for SQL 2000-- I can't do VARCHAR(max) and VARCHAR(8000) isn't large enough.</p>