Viewing Extended Properties in EM

Question

Viewing Extended Properties in EM

dean gross

SSCrazy

Points: 2632
More actions
April 15, 2005 at 8:03 am

#163244

Is there any way to view the Extended Properites of object in Enterprise Mgr? Being able to view the Table Description property (like I can in Access) would be very helpful.
April 18, 2005 at 8:00 am

This was removed by the editor as SPAM

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 1

If they are named according to the standards expected by Enterprise Manager, then you can view a description in EM. Right click the table, Design Table. The field description contains the extended property. This article contains some information:

Managing Extended Properties

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

dean gross SSCrazy Points: 2632 More actions · Answer 2

Thanks, but this approach only works for one table at a time. what I would like to be able to do is view the descriptions for all of the tables at once.

noeld SSC Guru Points: 96590 More actions · Answer 3

As you have discovered there is no GUI list interface to that info but you could write a query to extract it

Have a look at fn_listextendedproperty in BOL

hth

* Noel