Monday, January 21, 2013

MSSQL Check if Function or Procedure has changed

I use this query to check if a procedure or function has changed in the past 5 days:
[code]
SELECT * from ods.information_schema.routines i where routine_type in ('PROCEDURE' ,'FUNCTION') AND LAST_ALTERED > getdate() - 5
[/code]

Till Next Time

No comments: