Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Results Set documentation

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-14 : 07:16:54
Andrew writes "I have been documenting our databases here at Ruesch for 3 years, and I'm looking to add new elements to our documentation suite (which contains about 9000 objects now). Many of our stored procedures return record sets, sometimes from a single source (table or temp table), sometimes from multiple sources (joins on many tables), and sometimes conditionally: if X is true, return record set A; if Y is true, return record set B, etc.

Currently we are documenting these record sets simply by indicating each record in the set and the source, tagging the comment (I use Document! X from Innovasys to generate our document files), and then compiling everything into a Web site (using Macromedia RoboHelp 4.0).

We'd like to take this one step further, automating the documentation of record sets and adding data type information for all stored procedures that return record sets to the documentation.

Is there a documentation tool out there that might accomplish this goal?

Andrew Lakritz
Ruesch International"
   

- Advertisement -