Not sure how thoroughly this was tested on SQL Server, but I got a lot of errors with the included tool

[lunny]

Not sure how thoroughly this was tested on SQL Server, but I got a lot of errors with the included tool and it appears to have some serious shortcomings (VARCHAR(MAX) doesn't work, and it doesn't quote the names). This is my modified query although I am still having errors due to unique index dependencies.

SELECT 'ALTER TABLE [' + OBJECT_NAME(SC.object_id) + '] ALTER COLUMN [' + SC.name + '] NVARCHAR(' +
CASE WHEN SC.max_length = -1 THEN 'MAX' ELSE CONVERT(VARCHAR(5), SC.max_length) END
+ ')'

FROM SYS.columns SC
JOIN SYS.types ST
ON SC.system_type_id = ST.system_type_id
AND SC.user_type_id = ST.user_type_id
WHERE ST.name ='varchar'

Originally posted by @edwardforgacs in #24105 (comment)

[techknowlogick]

@edwardforgacs could you provide the server version of MSSQL that you use?

[edwardforgacs]

It's SQL 2019 but this won't affect the syntax issues I mentioned.