SELECT crdate,
i.name,
object_name(o.id)
FROM
sysindexes i
JOIN sysobjects o ON o.id = i.id
WHERE i.name like'%tablename%'
ORDER BY crdate DESC