I am using Extended properties for ages. But I agree with Phil - vendor should provide better Documenting facilities,

rather than force us to "re-invent the wheel" in DIY solutions!

murph_32952 (2/26/2010)

---

Rename potentially obsolete objects by appending a "z" or "zzz" to the front of the object name. If the object is required, someone will get an error. ...

Perform Impact Analysis - which database objects are used and find out a dependency chain.

DO NOT rename database object with prefixes/suffixes - add your comment to dedicated key in...

Forget about EXCEL, I like an idea to have a SINGLE point of execution for ANY Stored procedure in database. Will try for output parameters....

Steve,

Thank you for your article. I would like to add my 2 cents:

- xml data-type should be and must be strongly-typed (i.e. client has to pass not just well-formed...

Politically incorrect answers - should we AVOID to query sys table directly and use system Information_schema system views instead?