[dba-SQLServer] Test for empty columns

My database from hell has at least some columns where the column simply contains no data in any 
record.  I am wondering how I would find and list these columns so that I can delete them from my table.

Would I write a stored procedure to get the columns from the database and then just iterate through 
that recordset building a dynamic query?  Is there already something out there that does this? 
Anybody doing this?

TIA,

-- 
John W. Colby
www.ColbyConsulting.com