Determining when stored procedure has been modified

vishalneeraj-24503
Posted by vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 1112
Using sys.procedures tables ,we can track when any Stored Procedure was modified.
SELECT [Name] as Stored_Proc_Name,Modify_Date,Create_Date FROM sys.procedures;

Above query will give us a list of SP. which was modified.

Comments or Responses

Login to post response