List the length of every field in the table

gistfile1.sql

DECLARE @table SYSNAME, @field SYSNAME

set @table = '## Your table name ##'

CREATE TABLE #Temp (TableName SYSNAME, ColumnName SYSNAME, MaxLength INT)

DECLARE a_cursor CURSOR STATIC
FOR
SELECT name FROM syscolumns c WHERE id = object_id(@table)
OPEN a_cursor

FETCH NEXT FROM a_cursor INTO @field
WHILE @@FETCH_STATUS = 0
BEGIN
INSERT INTO #temp
EXEC ('select ''' + @table + ''', ''' + @field + ''', max(len(' + @field + ')) from ' + @table )
FETCH NEXT FROM a_cursor INTO @field
END

CLOSE a_cursor
DEALLOCATE a_cursor

SELECT * FROM #Temp

DROP TABLE #Temp