Here is something new about SQL Server 2005.  The varchar, nvarchar, and varbinary supports a max length.  Instead of being limited to 8000 characters in the past, this new data type supports up to 2GB of data.  No longer do you have to use text, ntext, and image data types.  In fact these data types have been marked for deprecation in the future.

Read the complete post at