When I run
SELECT count(object_id) AS count, object_id, min(name) as name1, max(name) AS name2 FROM sys.indexes GROUP BY object_id HAVING COUNT(*) > 1 ORDER BY count
I will get a list of indexes having the same
object_id, but not necessarily with the same name.
Should not all indexes with the same
object_id have the same name?