I was browsing google searching for information on data types as I was creating a new table in my db. Just wanted to make sure I was doing things right and I came across this snippet notifying of the following:
ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead.
Fixed and variable-length data types for storing large non-Unicode and Unicode string and binary data. Unicode data uses the UNICODE UCS-2 character set.
So in this particular table I did use varchar(MAX) instead of text. Didn't even know there was varchar(max) or I forgot.