• You can use below query:

    sp_stored_procedures. Just try it once.

    Thanks,

    Arif.