<div>
These are good guys. &nbsp;I will have to write scripts around these 3 SPs. &nbsp;For instance, I will have to check for an attribute's existence first prior to UPDATE.. thing like that.. <br />
but this should work..<br />
Meanwhile, if you guys have snippets of some associated scripts then please share ;) <br />
thx
</div>


These are good guys.  I will have to write scripts around these 3 SPs.  For instance, I will have to check for an attribute's existence first prior to UPDATE.. thing like that..
but this should work..
Meanwhile, if you guys have snippets of some associated scripts then please share ;)
thx

<div>
In order to check for existence consider using either <br />
sys.fn_listextendedpropert<wbr />y<br />
<a href="http://msdn.microsoft.com/en-us/library/ms179853(v=sql.105).aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms179853(v=sql.105).aspx</a><br />
<br />
Or:<br />
sys.extended_properties<br />
<a href="http://msdn.microsoft.com/en-us/library/ms177541(v=sql.105).aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms177541(v=sql.105).aspx</a>
</div>


In order to check for existence consider using either
sys.fn_listextendedproperty
http://msdn.microsoft.com/en-us/library/ms179853(v=sql.105).aspx [http://msdn.microsoft.com/en-us/library/ms179853(v=sql.105).aspx]

Or:
sys.extended_properties
http://msdn.microsoft.com/en-us/library/ms177541(v=sql.105).aspx [http://msdn.microsoft.com/en-us/library/ms177541(v=sql.105).aspx]

<div>
I have started to build my automated routines to update my USP and UDF EP attributes.<br />
thx
</div>


I have started to build my automated routines to update my USP and UDF EP attributes.
thx

<div>
<div class="content wysiwyg-content">
Hello Team,<br />
<br />
Is there an easy way to programmatically (using TSQL) update/add/delete extended property attributes and values on objects in SQL server? <br />
<br />
<br />
Thx <br />
<br />
JohnE
</div>
</div>


Hello Team,

Is there an easy way to programmatically (using TSQL) update/add/delete extended property attributes and values on objects in SQL server? 


Thx 

JohnE

SQL: ExtendedProperties::

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.