Tidied formatting. Faux-parameterised queries for the sake of readability.
Now only refreshes view metadata if at least one column of type NTEXT was found.
Now generates and will optionally execute scripts to alter columns in multiple databases.
Generalised single database script to work on all large data type columns and convert them to modern equivalents: NTEXT -> NVARCHAR(MAX); TEXT -> VARCHAR(MAX); IMAGE -> VARBINARY(MAX).