Friday, January 31, 2014

how to know store procedure created date

SELECT namecreate_datemodify_dateFROM sys.objectsWHERE type 'P'AND name 'lsp_PropGetCrntSugsn'





SELECT nameFROM sys.objectsWHERE type 'P'AND DATEDIFF(D,modify_dateGETDATE()) < 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_dateGETDATE()) < 7----Change 7 to any other day value.

No comments:

Post a Comment