SQL Server; change all "TEXT" columns to "VARCHAR(MAX)"

Long text (Memo) type columns in SQL Server use a data type of "TEXT" Unfortunately this data type will be removed in a future version of SQL Server.

Therefore all "TEXT" columns have been updated to "VARCHAR(MAX)".

For more information see https://docs.microsoft.com/en-us/sql/t-sql/data-types/ntext-text-and-image-transact-sql.