Sometimes people add new stored procedures to your SQL Server database without your knowledge. You need a way to detect new stored procedures using Transact-SQL.
SELECT name,sys.objects.create_date FROM sys.objects WHERE type='P' AND DATEDIFF(D,sys.objects.create_date,GETDATE());
Just change the value of “D” to match the number of days to check. If you use a “7”, this script will show those stored procedures created in the last 7 days.