LinkedIn

Wednesday, 23 March 2011

Finding all stored procedures updated in the last (n) days

This was quite helpful:
SELECT name
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,modify_date, GETDATE()) < 30