Check When A Stored Proc Changed
Knowing if a stored procedure has been modified can be useful when you need to check the database in case of a sudden change in performance. The method I will show you will not tell you who changed the stored proc but at least you’ll know if it has been changed.
Just run a scheduled job either daily or weekly that executes the the stored procedure below:
This is script to create the table:
This will log into a table the stored procedure name, the database name and the date it changed.
If you suddenly have a stored procedure that isn’t performing as it should, then this is a quick 1st check to see if it has been changed without you being aware.