NTEXT is a variable-length data type that can store long Unicode character strings.
NTEXT can hold up to 2,147,483,647 bytes of data.
The actual storage used depends on the length of the character string.
NTEXT has been deprecated and will be removed in some future release of SQL Server.
Use NVARCHAR(Max) instead.