>>>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.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com