Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Need to read SQL 2000s extended property like Tables "Description" ...

Hi,

I need to read the Table -property or collumn-property "Description" (that
is new in SQL-Server 2000) from ASP and ADO. But there seems to be no library,
that is able to read this property.

I tried ADO's Connetion object's adSchemaTables method, The "Description"
is always "empty" (or Null?), I think this is NOT the extended property I
need, cause I am sure the Table's "Description" property has somrhthing there
(WE put in some words when in Desing Table-> "Table and Index Property" ->
Description...

Does anyone knows a solution?

Thanks Kai
[631 byte] By [Kai] at [2007-11-9 21:11:06]