2 Answers
2

If you want to retrieve the "descriptions" you set using MSSMS's UI you need to query sys.extended_properties.

Start by doing select * from sys.extended_properties and read some records in the value column to know what I mean (you'll find previously set descriptions there). You will later need to do some joins with sysobjects (I guess) in order to know which description belongs to which table and you'll be ready to go. Search in google for more info if you're confused =)