Link to home
Start Free TrialLog in
Avatar of hindersaliva
hindersalivaFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Need SQL Server documentation ideas

I need to document my SQL 2008 R2 Server database in a specific way. For each Stored Procedure I need to identify which Tables and Columns are involved - preferably have the result in a normalised table.

I have DocumentX 2010 but it does not appear to expose a database of its documentation. I am hoping that SQL Server itself can be queried for this. Are there any other documentation programs out there that may help?

Background: I build solutions with Excel VBA and SQL Server in an 'extreme programming' kind of way (another name for hacking?). Soon I have tables and columns that are never used in the final application, and mess! I like to be able to generate a dependencies tree at any stage - from the Excel UI > Excel VBA > Class Modules > SQL Server Stored Procedures > Tables/Views > Columns. Will help reduce the mess/confusion and serve as part of the final documentation.

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of raulggonzalez
raulggonzalez

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hindersaliva

ASKER

Brilliant. Exactly what I needed.