This tutorial shows you how to get list of stored procedures in SQL Server 2008/2012/2014/2016/2019.
The best way to list all stored procedure in sql database server is to use information_schema.
select * from information_schema.routines where routine_type = 'PROCEDURE'
or you can also query from dbo.sysobjects to get all stored procedure text in sql server.
SELECT name, type FROM dbo.sysobjects WHERE (type = 'P')
If you want to return all procedures in selected database, you can use the following sql script
SELECT * FROM sys.procedures
As you can see, it's easy to get list of user defined stored procedures in sql server.