SQL Server获取存储过程、表、自定义函数的最后修改时间
select [name], create_date, modify_date, type_desc FROM sys.all_objects where
(type_desc = N'SQL_STORED_PROCEDURE' OR
type_desc = N'SQL_TABLE_VALUED_FUNCTION' OR
type_desc = N'SQL_SCALAR_FUNCTION' OR
type_desc = N'USER_TABLE') AND schema_id <> 4 order by type_desc asc, modify_date desc