Be aware that in future versions of SS, the TEXT data type will be REMOVED! see BOL topic "Using text and image Data" http://msdn2.microsoft.com/en-us/library/ms189574(SQL.90).aspx

Microsoft has introduced a new data type option called (MAX) to the varchar and binary types. It is an enhanced version of the text types and can do a lot more. If you upgraded to SS2005 then it is very recommended that you start using this option if you use large data. To find out more see the SS BOL topic "Using Large-Value Data Types" http://msdn2.microsoft.com/en-us/library/ms178158.aspx

As an example, consider the previous user's comment re triggers. Now, it is possible to use large data inside triggers using this new data type. There is a lot more info in BOL (search for varchar(max) ).