Veeam is happy to provide a free NFR license for one year. It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.
Solved
Need SQL Server documentation ideas
Posted on 2011-03-05
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:
ht…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
…
Suggested Courses
Course of the Month11 days, 8 hours left to enroll
719 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.