Table and Query Descriptions in ADP

A

Alan Z. Scharf

Is there a way to fill in the Database Window Description column for
SQLServer Objects?

Thanks.

Alan
 
A

aaron.kempf

gosh... you know i sure wish that there was.

i also wish that they.. get this

HAD QUERY MODIFIED DATES AND TABLE MODIFIED DATES
i mean-- isn't that tracked in sysobjects?

it should be lol
 
M

Malcolm Cook

To change the description of an object, open it in design view and select 'Edit Properties' then edit the description.

This is stored in SQL Server as an extended property named 'MS_Description' and is visible using SQL Query Analyzer and
programatically retrievable via fn_listextendedproperty (c.f. BOL) but does NOT display in MS Access's database window - too bad.
 
A

Alan Z. Scharf

Malcom,

Thanks for the info.

Alan


Malcolm Cook said:
To change the description of an object, open it in design view and
Click to expand...
select
'Edit Properties' then edit the description.
This is stored in SQL Server as an extended property named
Click to expand...
'MS_Description' and is visible using SQL Query Analyzer and
programatically retrievable via fn_listextendedproperty (c.f. BOL) but
Click to expand...
does NOT display in MS Access's database window - too bad.
 
Top