List the User-Defined Functions which got modified in last 7 days

Posted by Professionaluser under Sql Server category on | Points: 40 | Views : 123
SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'FN' -- lists out all the FUNCTIONs in current database
AND DATEDIFF(D,modify_date, GETDATE()) < 7 -- this condition filters result set of last 7 days modified objects(Functions)

Comments or Responses

Login to post response