gavinparnaby :

If I undestend you correclty you are saying you are getting there is a resultset of duplicate indexes of differnt tables. I need to be corrected here. Indices are other data structures grouped in a DMV called sys.indexes. So, these tables have the same index names. check the names of the tables and run this stored proc under that Database :

sp_helpindex '<tablename>' . you will make sure that they share the same names OR

run : select o.Object_id, o.name AS TableName, i.Name AS IndexName

FROM sys.Objects o

INNER JOIN sys.indexes i

ON o.Object_id = i.object_ID

AND o.type = 'U'

ORDER By o.name , i.Name

You will be able to see duplicates. If the TableName and Object_Id are the same then conclude that you are actually duplicating one thing(same object)