Stored Procedures Modified in last 7 Days Posted on March 3, 2017 by admin SELECT name, create_date, modify_date FROM sys.objects WHERE type = 'P' and modify_date>=DateAdd(Day,-7,GetDate())