SELECT [name], [object_id], [create_date], [modify_date]
  FROM sys.all_objects
 WHERE [type] = 'P' AND [object_id] > 0
 and name = 'name_sp'
 ORDER BY [modify_date] DESC