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.