Does anybody know how I can get a list of all my stored procedures names, parameters, and the columns in the select statement? I need this for documentation of my application.
the stored procedure 'sp_stored_procedures' will give u the list of all stored procedures (both system & user) in the current environment. let me know if this helps
Thanks for the reply. I ran it and it seemed to work. Although it just displays -1 for the number of input and output parameters. How do I find out what SP's like this are available?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.