SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
and name like '%pr_test_block%'
AND DATEDIFF(D,modify_date, GETDATE()) < 30

By doing this you can track the proc changes:




create table 
dbo.AdministratorLog(databasename varchar(256)
, eventtype varchar(50),objectname varchar(256)
, objecttype varchar(25), sqlcommand varchar(max), loginname varchar(256),Modifieddate datetime)




alter TRIGGER [Admin_Backup_Objects]

ON DATABASE

FOR create_procedure, alter_procedure, drop_procedure,

create_table, alter_table, drop_table,

create_function, alter_function, drop_function

AS



SET NOCOUNT ON



DECLARE @data XML

SET @data = EVENTDATA()


--drop table AdministratorLog
INSERT INTO dbo.AdministratorLog(databasename, eventtype,objectname, objecttype, sqlcommand, loginname,Modifieddate)

VALUES(

@data.value('(/EVENT_INSTANCE/DatabaseName)[1]', 'varchar(256)'),

@data.value('(/EVENT_INSTANCE/EventType)[1]', 'varchar(50)'),  -- value is case-sensitive

@data.value('(/EVENT_INSTANCE/ObjectName)[1]', 'varchar(256)'), 

@data.value('(/EVENT_INSTANCE/ObjectType)[1]', 'varchar(25)'), 

@data.value('(/EVENT_INSTANCE/TSQLCommand)[1]', 'varchar(max)'), 

@data.value('(/EVENT_INSTANCE/LoginName)[1]', 'varchar(256)'),
getdate()

)


alter procedure pro
as
begin 

 select getdate()
 end 


select * from dbo.AdministratorLog