Is it possible to change the size limit on
ntext fields in SQL Server 2005 or must one convert the field to
The size limit on the CLOB/BLOB fields are fixed (n/text, and image) to 2,147,483,647 bytes. Those datatypes are deprecated as of SQL 2008 and probably won't be included in the next version.
Their updated versions are the varchar(max), nvarchar(max), and varbinary(max) datatypes and they have the same limits. Note that the 'n' prefix in nvarchar and ntext means that Unicode characters are stored in the field, so the real translation from ntext should be to nvarchar(max).
Hope that helps!
You must convert to varchar(max). The limit is hard coded and cannot be controlled in any other way outside of a feature request to Microsoft.
However I highly doubt it will be allowed since it is has been flagged for removal in future version of SQL Server as per MSDN here.
To add to what's already been said:
Hope this helps