How to list all stored procedure from the SQL Server database?

To list all user stored procedure from the database, use following code.

SELECT name FROM sys.procedures

To print all name of the stored procedure using Cursor, use following code

DECLARE @name VARCHAR(50) -- database name  
DECLARE db_cursor CURSOR FOR  

SELECT name FROM sys.procedures;

OPEN db_cursor   
FETCH NEXT FROM db_cursor INTO @name   

WHILE @@FETCH_STATUS = 0   
BEGIN   
       print @name
       --sp_helptext ''+ @name + ''

       FETCH NEXT FROM db_cursor INTO @name   
END   

CLOSE db_cursor   
DEALLOCATE db_cursor