SELECTDB_NAME() AS DATABASENAME,

OBJECT_NAME(B.OBJECT_ID) AS TABLENAME,

B.NAME AS INDEXNAME,

B.INDEX_ID

FROMSYS.OBJECTS A

INNER JOIN SYS.INDEXES B ON A.OBJECT_ID = B.OBJECT_ID

WHERENOT EXISTS (SELECT *

FROM SYS.DM_DB_INDEX_USAGE_STATS C

INNER JOIN master.sys.databases DB ON C.database_id = DB.database_id

WHERE B.OBJECT_ID = C.OBJECT_ID AND DB.name LIKE '%'

AND B.INDEX_ID = C.INDEX_ID

) AND A.TYPE <> 'S'

AND B.NAME > ''

AND B.NAME not like '%rowid%'

ORDER BY 1, 2, 3