InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 19:53:10 GMT20http://www.sqlservercentral.com/Forums/Topic1085294-1497-1.aspxHi Toby,The next (and final) article does indeed contain scripts to document a data dictionary, using the database metadata - let me know if you like it once it appears.Regards,AdamWed, 30 Mar 2011 01:58:33 GMTAdam Aspinhttp://www.sqlservercentral.com/Forums/Topic1085294-1497-1.aspxThanks for the article Adam. It is well thought out, and well presented and written. I have used a exists then update or add methodology. I've only ever added extended properties for databases, tables, and stored procedures because I encourage naming to be as self explanatory as possible. However, if the database schema was controlled by a third party, and/or the column names and paramter names were criptic then I could definitely see benefit to describing them with extended properties. One of the potential uses of extended properties is the ability to build a data dictionary which I am hoping you will have a script for in the next article of the series. I have a decent script for doing this in case you don't already have one built. It's not in my coding style so I didn't write it, and regretfully I don't have a comment at the top to give the author proper credit.Tue, 29 Mar 2011 10:10:57 GMTToby Whitehttp://www.sqlservercentral.com/Forums/Topic1085294-1497-1.aspxThanks Sanjay, I hope that the series proves useful.AdamTue, 29 Mar 2011 09:23:01 GMTAdam Aspinhttp://www.sqlservercentral.com/Forums/Topic1085294-1497-1.aspxGreat article, Adam. I will save it in my briefcase for future reference.Tue, 29 Mar 2011 08:47:41 GMTSanjayAttrayhttp://www.sqlservercentral.com/Forums/Topic1085294-1497-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Metadata/72609/">Modifying and deleting extended properties</A>[/B]Mon, 28 Mar 2011 22:56:05 GMTAdam Aspin