Check when the MS SQL Store Procedure were updated

To check the MS SQL Store Procedures updated date and time use this SQL statement.

SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
ORDER BY modify_date DESC

Some time when you are developing. It is hard to keep track of the SP when they got updated or not this way you will know which SP to move to the live server from your development server.