SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = ‘P’
AND MONTH(modify_date)=11 AND  YEAR(modify_date)=2016
ORDER BY modify_date DESC

Advertisements