You can get list of modified stored procedures by using following:
SELECT name FROM sys.objects WHERE type = ‘P’ AND DATEDIFF(D,modify_date, GETDATE()) < 7
You can get list of modified stored procedures by using following:
SELECT name FROM sys.objects WHERE type = ‘P’ AND DATEDIFF(D,modify_date, GETDATE()) < 7