SELECT name, create_date, modify_dateFROM sys.objectsWHERE type = 'P'AND name = 'lsp_PropGetCrntSugsn'
SELECT nameFROM sys.objectsWHERE type = 'P'AND DATEDIFF(D,modify_date, GETDATE()) < 7----Change 7 to any other day value
Following script will provide name of all the stored procedure which were created in last 7 days, they may or may not be modified after that.
SELECT nameFROM sys.objectsWHERE type = 'P'AND DATEDIFF(D,create_date, GETDATE()) < 7----Change 7 to any other day value.
No comments:
Post a Comment