Solved

Need SQL Server documentation ideas

Posted on 2011-03-05
2
372 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:hindersaliva
2 Comments
 
LVL 8

Accepted Solution

by:
raulggonzalez earned 500 total points
ID: 35043762
Actually you go can try to use

sp_depends YourProcName

See what the output is and try to use it to insert into an audit table at your convenience...

Good luck!
0
 

Author Closing Comment

by:hindersaliva
ID: 35043966
Brilliant. Exactly what I needed.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question