转自Insus.NET
获取MS SQL Server用户存储过程最近修改日期
SELECT [name], [create_date], [modify_date] FROM [sys].[objects] WHERE [type] = 'P' ORDER BY [modify_date] DESC //这是获取修改存储过程的修改时间的语句SELECT [name],[create_date] , [modify_date] FROM [sys].[objects] WHERE [type] IN('P','U','IF','TR') --存储过程,用户表,自定义函数,触发器 ORDER BY [modify_date] DESC//这是获取修改存储过程,用户表,自定义函数,触发器的修改时间的语句 感觉还是有点不准确 ,有些我修改了的存储过程,没有显示出来 查询数据库大小 SELECT DB_NAME(database_id) AS [Database Name],[Name] AS [Logical Name],[Physical_Name] AS [Physical Name],((size * 8) / 1024) AS [Size(MB)],[differential_base_time] AS [Differential Base Time] FROM sys.master_files WHERE DB_NAME(database_id) IN('XXX')//xxx代表数据库的名字