To check the MS SQL Store Procedures updated date and time use this SQL statement.
SELECT name, create_date, modify_date
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.