Saturday 11 May 2019

MSSQL - Check stored procedure's last modified date



Watch this example on YouTube


SELECT name, create_date, modify_date
FROM sys.objects
WHERE Type='P' and name = 'PROCEDURE NAME'
ORDER BY modify_date DESC

No comments:

Post a Comment