How to check date of last change in stored procedure or function in SQL

SELECT * FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = N'PROCEDURE' and ROUTINE_SCHEMA = N'dbo' 
order by  LAST_ALTERED desc
  SELECT * FROM INFORMATION_SCHEMA.ROUTINES
  WHERE ROUTINE_TYPE = N'PROCEDURE' and ROUTINE_SCHEMA = N'dbo' 
  order by  CREATED desc 

  SELECT * FROM INFORMATION_SCHEMA.ROUTINES
  WHERE ROUTINE_TYPE = N'FUNCTION' and ROUTINE_SCHEMA = N'dbo' 
  order by  LAST_ALTERED desc

  SELECT * FROM INFORMATION_SCHEMA.ROUTINES
  WHERE ROUTINE_TYPE = N'FUNCTION' and ROUTINE_SCHEMA = N'dbo' 
  order by  CREATED desc 

Share

& Comment

Tweet