How to get the list of stored procedure ?

  • Thread starter Thread starter Lloyd Dupont
  • Start date Start date
L

Lloyd Dupont

Basically I have a SqlConnection and I would like to be able to
automatically fetch a list of stored procedure in the server and be able to
cull out all which have parameters (I need the list of parameterless
procedures)

anyway or clues on how to do that ?
 
Hi Lloyd,

Try the following selects:

select * from INFORMATION_SCHEMA.ROUTINES
select * from INFORMATION_SCHEMA.PARAMETERS
 
great ! thanks ;-)

Miha Markic said:
Hi Lloyd,

Try the following selects:

select * from INFORMATION_SCHEMA.ROUTINES
select * from INFORMATION_SCHEMA.PARAMETERS
Click to expand...
 
Back
Top