If you want to retrieve the latest modified stored procedure in TSQL. You can query the latest changes by looking into the sys.objects table with column type equals to 'P'.

Here is the TSQL query to get the latest modified stored procedure in SQL Server.

SELECT * 
FROM sys.objects
WHERE type = 'P'
ORDER BY modify_date DESC