Friday, April 3, 2015

sql server get stored procedures updated in specific period

use your database
SELECT *
    name,
    create_date,
    modify_date
FROM sys.procedures
WHERE modify_date >= '20150301'



--- get all objects changes in period

SELECT
    *
FROM sys.all_objects
WHERE modify_date >= '20150301'



No comments:

Post a Comment