>I am building a small tool that will be used to compare 2 database to find differences. I want this
>tool to work at least with SQL and Access databases.
>
>For that topic I use a mixture of ADO and ADOX (to have the most detail possible).
>
>My problem for now is that I can retreive the Description field for Access tables and columns but not
>for SQL.
>
>This is my code to get the description:
>

   ' ----- Retrieve the description from standard ADO since ADOX doesn't
>   '       have it recorded.
>   Set rsInfo = connSchema.OpenSchema(adSchemaTables, _
>       Array(Empty, Empty, sTableName, "TABLE"))
>   If Not (rsInfo.EOF) Then GetTableDesc = rsInfo!Description & ""

>
>
>How can I retreive that?

You mean SQL Server? AFAIK SQL Server does not support field descriptions. I don't know if there is even a place where you can enter some type of comments for a field in SQL Server.

I haven't used SQL Server 2000 enough to say if it's there or not, but I believe it's still the same as SQL7 as far as this goes.