Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Modifying and deleting extended properties Expand / Collapse
Author
Message
Posted Monday, March 28, 2011 10:56 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, September 18, 2014 7:03 AM
Points: 81, Visits: 903
Comments posted to this topic are about the item Modifying and deleting extended properties
Post #1085294
Posted Tuesday, March 29, 2011 8:47 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
Great article, Adam. I will save it in my briefcase for future reference.



SQL DBA.
Post #1085601
Posted Tuesday, March 29, 2011 9:23 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, September 18, 2014 7:03 AM
Points: 81, Visits: 903
Thanks Sanjay, I hope that the series proves useful.

Adam
Post #1085633
Posted Tuesday, March 29, 2011 10:10 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, November 9, 2012 2:48 PM
Points: 493, Visits: 636
Thanks 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.

  Post Attachments 
Data_Dictionary.docx (6 views, 20.49 KB)
Post #1085689
Posted Wednesday, March 30, 2011 1:58 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, September 18, 2014 7:03 AM
Points: 81, Visits: 903
Hi 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,
Adam
Post #1086023
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse