Ian Bailey

Useful bit of code, which I’m kinda putting here so I can access it easily. It will display the date created and last modified dates of stored procedures, which can be useful to see when you last made a code change etc!

Anyway:

SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = ‘P’
ORDER BY modify_date