You can use below query:

sp_stored_procedures. Just try it once.

Thanks,

Arif.