List stored procedures name and parameters 1

[dokken]

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.

Thanks
Paul

 

[pmanivas]

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

 

[dokken]

Where would I find this stored procedure? I don't see it in my list of system SP.

Thanks
Paul

 

[pmanivas]

you don't need to find that sp. you just run
Exec sp_stored_procedures
in ur query analyser

 

[dokken]

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?

Thanks,
Paul

 

[pmanivas]

you can find this type of SPs in Master DB of any SQL server

 

[Terryute]

Use this query in any database as each database has it's own procs.

Select Name From Sysobjects where xtype = 'p'

below optional for specific type searches:

and Name like '%<search criteria>%'

The master database usually only stores system procs.
User defined procs usually reside in in user created
databases.

I hope that can help.