CORRECTION.  The prior posted sql may have duplicates.  The following should work better:

--List tables, columns and column descriptions

select SO.name as 'table', SC.name as field,

ST.name as datatype, SC.length as 'size',

sp.value as 'description'

from syscolumns SC inner join

sysobjects SO on SC.id = SO.id inner join

systypes ST on ST.xusertype = SC.xusertype left join

sysproperties sp on  sp.id = so.id and sp.smallid = SC.colid

and sp.name = 'MS_Description'

where SO.xtype = 'U' and SO.status > 0

order by SO.name, SC.name