Listing All stored procedures which got MODIFIED in last 7 days

Posted by Professionaluser under Sql Server category on | Points: 40 | Views : 99
Below query gives you the list of stored procedures which got changed in last 7 days....
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,modify_date, GETDATE()) < 7

Note : You can change the 7 number in the WHERE condition with N -- here N represents the number of days

Comments or Responses

Login to post response