Here is a small snippet, to find the recently added stored procedure that you created in your sql server, this can be useful when did not keep track of the stored procedures in your project.

select * from sys.objects where [type] = 'P' order by create_date Desc