• For those of you who want to use the extended properties and think that there is no extended properties for the table in general, there is a way to enter it directly from Enterprise Manager.

    When you are in Design Table, right click one of the columns and chose Properties.  The field called Description on the Tables tab is stored in the extended properties.

    You can access it from a script with:

    SELECT @tabledesc = value

     FROM   ::fn_listextendedproperty(NULL, N'user', N'dbo', N'table', @tblname, DEFAULT, DEFAULT)

    I have a script called usp_Table_Doc that takes the table name as a parameter outputs a file layout, complete with the extended properties as descriptions, if anyone is interested.

    Steve