Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 DB objects - Extended properties

Author  Topic 

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-06-25 : 12:26:10
DB objects (e.g. tables) there is an option EXTENDED PROPERTIES, where i can define a name and value.

How to get this value from query editor?

------------------------
I think, therefore I am - Rene Descartes

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-25 : 12:53:51
So when you typed in extended properties into SQL Server Books Online, you weren't able to find this information? I found it in 3 seconds.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-06-25 : 12:58:10
Thank you Tara! Totally forgot BOL! I found the info in BOL, it took me 5 seconds. I have a slower machiene ;-)

------------------------
I think, therefore I am - Rene Descartes
Go to Top of Page
   

- Advertisement -