Hi Borissov,

Just FYI, apparently this will not work in SQL 2000, complaining that sys.extended_properties was not an object.

After tinkering with Sergey's solution ( via Naomi ), I was able to retrieve the data.

Bill

>
>This works on SQL 2005 (I can't test it right now on SQL 2000)
>

>SELECT *
> FROM sys.extended_properties
>LEFT JOIN INFORMATION_SCHEMA.Columns
>ON OBJECT_NAME(Major_Id) = INFORMATION_SCHEMA.Columns.Table_Name AND
>   Minor_Id = INFORMATION_SCHEMA.Columns.Ordinal_Position
>WHERE Class = 1
>