Get Stored Procedure Last Modified Date or Updated Date in SQL Server

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

If we want to get specific procedure modified date we need to write the query like this

SELECT name, create_date, modify_date FROM sys.objects WHERE type = 'P' AND name like '%your procedure name%'

Next Recommended Reading Get Week Start Date & Week End Date Using SQL Server