Script to get Stored procedure that are created in Last N Days in Sql Server.

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

Note:- Change 30 to any other day value.

Comments or Responses

Login to post response