Did you know that SQL 2005 only supports text, ntext, and image data types for backward compatibility purposes? The preferred storage for large data is to use the varchar(max), nvarchar(max), and varbinary(max) data types, where max indicates that the maximum storage size is 2^31-1 bytes.

 

Note: both AFTER and INSTEAD OF triggers support using varchar(max), nvarchar(max), and varbinary(max) data in the inserted and deleted tables.