Program Documentation for Stored Procedure ?

  • Hi All,

    We program intensively in TSQL / stored Procedure, many business logic is in

    there. And I need to distribute the jobs to some SQL programmers.

    Is there any documentation tool that can properly / precisely dedscribe the

    flow of TSQL programs / stored procs ?

    Thanks for any help,

    Krist

  • Why aren't you using DTS packages to distribute the jobs and as documentation?  Are these not sufficient for your business logic needs? 

    The DTS repository can be used for this purpose.  Along with the META DATA features.  I assume you want to depict the dependencies and Just what steps are in the jobs.  Perhaps you call a lot of command or script steps that need explanation.  The text annotations can make this a little bit of a management detail.  But with the right internal standards and deployment practices this should work.

    Peter Evans (__PETER Peter_)

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply