Monday 20 February 2017

List of store procedure created and / or modified on a particular date



For getting list of store procedure which created or modified on a particular date, try below query

SELECT
    name,
    create_date,
    modify_date
FROM sys.procedures
WHERE modify_date = '20170220'
ORDER BY modify_date desc 

SELECT name
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,modify_date, GETDATE()) < 7

----Change 7 to any other day value


No comments:

Post a Comment