显示存储过程的名称、创建时间、修改时间

SELECT NAME,create_date,modify_date,* FROM sys.all_objects                                
WHERE ([type] = 'P' OR [type] = 'X' OR [type] = 'PC') AND [object_id]>0
ORDER BY [name];                                                         
GO