Script to get Stored Procedure that changes in Last N days in Sql Server.

Posted by Vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 188
SELECT Name as Stored_Procedure_Name
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,modify_date,GETDATE()) < 15;

Note:- Change 15 to any other day value of your choice.

Comments or Responses

Login to post response