SP_WASTED_SPACE will run through each column in your database and print a report of all the character columns. It will then print a report with :
* The maximum length that a column is storing
* The average length of data stored in each column
* The amount of wasted space in each column
* Hints on how to improve performance
Create the stored procedure in the Master database. No parameters are needed if you do that since the procedure reads what database you're in. Just attach to the target database and then run SP_WASTED_SPACE
Will compile only in SQL Server 2000.
It may take some time to run on large active databases, so I would recommend running it on a copy of the database.