title: Converting Text to varchar(MAX)
body: <p>I'm working currently on a SQL Server project that has been built for SQL Server 2000. In some tables of this project, the <code>Text</code> Datatype was used. Because have to do some bigger changes on this database(s), it would be a good occasion to change these fields to <code>VARCHAR(MAX)</code>. All SQL Servers are now 2005 and 2008.</p>
  
  <p>Are there any problems to be expected when I change all the <code>Text</code> datatypes to <code>VARCHAR(MAX)</code> or are all features that are supported by the <code>Text</code> datatype also supported by <code>VARHCHAR(MAX)</code>.</p>
  
  <p>As an additional information, the data from the database is queried mostly from a .net application, besides this, also excel, access and some statistical tools access the database directly via odbc/ole-db.</p>