Find the last modified date for all stored procedures
-- SQL stored procedure last modified date - SQL datetime to string conversion USE AdventureWorks2008 ; GO SELECT SchemaName = Schema_name ( schema_id ), SprocName = name , CreateDate = left( convert ( varchar , create_date , 120 ), 10 ), ModifyDate = left( convert ( varchar , modify_date , 120 ), 10 ) FROM sys . objects WHERE TYPE = 'P' AND is_ms_shipped = 0 ORDER BY SchemaName , SprocName GO For above example the out put is like below . OUT PUT: SchemaName SprocName ...