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