Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Manage Extended Property

By lxya,

     While we are exploring the possibility to build data-driven application whose GUI are all dynamically generated according to database objects' extended property, we find the system provided procedures: sp_addextendedproperty, sp_dropextendedproperty,sp_updateextendedproperty can add extended property to only one object each time, while fn_listextendedproperty can not let you search objects to display their extended property.

so I wrote a stored procedure which can let us manage extended property more efficiently.
      The procedure will first build an affected db object list by querying system catalog tables using the pattern specified by the passed in parameters and then call corresponding system procedures for all objects in the list.

Total article views: 438 | Views in the last 30 days: 1
Related Articles

Industrial-strength database documentation using Extended Properties

To finish this short series on extended properties a look at documenting sets of database objects


Modifying and deleting extended properties

Continuing the short series on extended properties, this article explains how to turbocharge the cre...


Extended Properties Introduction

Part one of a four part series intent on demystifying and making more accessible SQL Server extended...


Extracting Extended Properties

In this second article of a short series we look at using the Extended Properties which you have add...


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones