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.
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.
Microsoft SQL Server 2008
Last Comment
hindersaliva
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Brilliant. Exactly what I needed.