Hi Kris,

this is the same query for SQL 2005:

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

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

sp.value as 'description'

from sys.columns SC inner join

sys.objects SO on SC.object_id = SO.object_id inner join

sys.types ST on ST.user_type_id = SC.user_type_id left join

sys.extended_properties sp on sp.major_id = so.object_id and sp.minor_id = SC.column_id

and sp.name = 'MS_Description'

where SO.type = 'U'

order by SO.name, SC.name

Regarding your second question:

Just go to DB -> Views -> System views

Hope it helps.

Regards,

Jose