Pages

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

0 comments:

Post a Comment

I'd really appreciate your comments