Reading extended properties

[Chris Leffer]

Hi.

I have created some extended properties for my stored procedures in Sql
Server, like Description and Project. Can I use ado.net and vb.net to
read these extend properties and place them on a Listview? I dind't find
anything about this topic.

Regards,

Chris Leffer

 

[Nicole Calinoiu]

Chris,

You can use the system function fn_listextendedproperty to read the extended
property values. See
http://msdn.microsoft.com/library/en-us/tsqlref/ts_fa-fz_7l7t.asp for
details.

HTH,
Nicole

 

[William \(Bill\) Vaughn]

See http://www.betav.com/msdn_magazine.htm. I wrote an article on Extended
Properties a couple of years ago.
hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________