Manage Extended Property

     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. […]


455 reads


SSAS Tabular – Process Add memory consumption


For me it’s a bit surprising how little information can be found regarding the...

Our SQL Server 2019 Administration Inside Out Fun Author Survey


SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...

What's New in SQL 2019? at the Data Architecture Virtual User Group and Q&A followup


Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...

Read the latest Blogs


upgrade plan common sense check please

By snomadj

Be grateful for a yay or nay on my plan: 4 nodes. 2012.  1...

https //www.facebook com/ElectroKetoDietPills/

By haroldswansion

Electro Keto Many restaurants have lighter alternatives on the menus nowadays, some have reduced-fat...

Error switch partition

By samirca007

hello Good morning all I want to switch the partition from one table to...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers