Check the maximum length of a column

gistfile1.sql

DECLARE @sql VARCHAR(max)
SELECT @sql = ''

SELECT
	@sql = @sql + 'select ''' + table_name + ''',''' + column_name + ''',max(len([' + column_name + '])) from [' + table_name + '] union all '
FROM
	information_schema.columns

SET @sql = left(@sql, len(@sql) - 9)

EXEC (@sql)