Query for show user defined stored procedure in your DataBase in order

Select name from sys.procedures where [type] = 'P' and 

is_ms_shipped = 0 and [name] not like 'sp[_]%diagram%' 

order by name