Documenting large numbers of SPs

Hi All,

I have a large number of SPs that I would like to be able to document and provide this documentation to prospective clients. That is, provide them enough information without giving them the source code for the procedures.

I have found that all the parameters are in the sys.parameters table.

But I was wondering. Are the fields that are sent back out of an SP captured and recorded somewhere in the SQL Server catalog?

Is there an easy way to find out what fields are coming out of an SP?

Thanks in Advance

Peter

You may be better served exploring one of the third party documentation tools.

I like ApexSQL's Doc tool.

You can download a fully functional eval version.

|||

Hi Arnie,

thanks for the tip...I'll take a look..

Peter