Avatar of hindersaliva
hindersaliva
Flag 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.
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
hindersaliva

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
raulggonzalez

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
hindersaliva

ASKER
Brilliant. Exactly what I needed.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy