How to display column descriptions?

[bixgomez]

Hello!

I am wracking my brain, trying to figure out how to return & display a column's description.

I work in Cold Fusion with SQL 2000 database.

My table name is "clients" and the column in question is "client_firstname"

The description of this column, as entered in Ent. Mgr, is "First Name"

If anyone can please help me, it would be very greatly appreciated!

Thanks!

Now for the details...

I am trying this:

----------------------------------------------------------------
<cfquery name="get_ext2" datasource="#application.dsn#">
SELECT
objname As 'Column'
, value As 'Description'
FROM
::fn_listextendedproperty
('MS_Description', 'user', 'dbo', 'table','client', 'client_firstname', default)
</cfquery>

<cfoutput>
"#get_ext2.Column#"
"#get_ext2.Description#"
</cfoutput>
----------------------------------------------------------------

... and it is returning this:

"" ""

In my debug output, the query result appears as such:

----------------------------------------------------------------
get_ext2 (Records=0, Time=16ms)
SQL =
SELECT
objname As 'Column'
, value As 'Description'
FROM
::fn_listextendedproperty
('MS_Description', 'user', 'dbo', 'table','client', 'client_firstname', default)
----------------------------------------------------------------

Haaalp!

Thanks....

Richard