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
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