SQL Server 2008 – Get the List of Stored Procedures update/modify in last N number days

SQL, SQL-Advanced, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

With the help of the given procedure one can get the list of Stored Procedures update or modify in last N number days.

Script:

-- Get the List of Stored Procedures update/modify in last N number days 

CREATE PROCEDURE GetListModifySP
(
@days INT
)
AS
SELECT
name AS SP_Name, modify_date as Modfiy_Date FROM sys.objects
WHERE TYPE = 'P' AND DATEDIFF(DD,modify_date, GETDATE()) < @days

--Excecute the GetListModifySP
--You can give the N of days as per requirement 

EXEC GetListModifySP 10

Hope this will help you.

Related Posts

,