-- Collection of code snippets by Arne Vajhøj 
-- posted to eksperten.dk, usenet and other places (2002-now) 
SELECT 'ALTER TABLE ',TABLE_NAME,' ALTER COLUMN ',COLUMN_NAME, ' VARCHAR(',CHARACTER_MAXIMUM_LENGTH,')'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE DATA_TYPE='nvarchar'
