select i.name indexname, j.name tablename, o.crdate object_crdate, j.modify_date table_modifydate from sys.sysobjects o inner join sys.indexes i on o.id = i.object_id inner 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),crdate,112) = '20100920' and i.name like'%hede%' order by j.name,i.name asc
