Find when a SQL Server stored procedure or function was last altered with this script.
SELECT specific_catalog, specific_schema, routine_type, routine_name, created,last_altered FROM INFORMATION_SCHEMA.ROUTINES ORDER BY 1 asc, 2 asc, 3 asc, 4 asc
Andrew B writes: This tip is incorrect. There is no way to see when a stored procedure was altered. If you look at the source code to the view you will notice it returns the same data for CREATED and LAST_ALTERED -- see the following:
CREATED = o.crdate, LAST_ALTERED = o.crdate
For More Information
- Feedback: E-mail the editor with your thoughts about this tip.
- More tips: Hundreds of free SQL Server tips and scripts.
- Tip contest: Have a SQL Server tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize -- submit your tip today!
- Ask the Experts: Our SQL, database design, Oracle, SQL Server, DB2, relational model, and data warehousing gurus are waiting to answer your toughest questions.
- Forums: Ask your technical SQL Server questions--or help out your peers by answering them--in our active forums.
- Best Web Links: SQL Server tips, tutorials, and scripts from around the Web.