>>>>OK, I think SQL 2000 does have support for these with extended properties. But SQL7 does not have them.
>>>
>>>
>>>SQL 2000 has description feature for sure (I use it) and SQL 7 doesn't.
>>
>>Have you tried with ADOX and the properties collection? (in the column object) If it's going to read them you would probably need the OLEDB provider for SQL, as these are provider-specific.
>
>ADOX doesn't have Description in its properties.

Right. I'm not talking about the built-in properties, I'm talking about dynamic properties only found on the properties collection of various ADOX objects. These are also available in plain ADO.

See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdcolproperties.asp