select i.name indexname, j.name tablename,o.create_date,o.modify_date from sys.objects o inner join sys.indexes i on o.object_id=i.object_id right join sys.tables j on i.object_id=j.object_id where index_id>1 --- ( 0: HEAP index 1: PK index) --and convert(varchar(8),o.create_date,112) >= '20100727' order by o.modify_date desc
