查询数据库更改

DECLARE @beginDate DATETIMEDECLARE @endDate DATETIMESET @beginDate='2009-6-10'--时间开始SET @endDate=GETDATE()--结束时间SELECT '动作'=(CASE WHEN create_date>=@beginDate THEN 'create 'ELSE 'alter ' END),'类型'=(case [type] when 'p' then '存储过程' when 'u' then '表' when 'v' then '视图' else '' end),'对象名称'=[name],'修改时间'=modify_date,'创建时间'=create_dateFROM sys.all_objectsWHERE [type]='p' OR [type]='u' OR [type]='v' and modify_date between @beginDate AND @endDate ORDER BY modify_date DESC