select 'select *
from ' + name + '.sys.indexes i
where i.name =  ''typeYourIndexNameHere'''
from master.sys.databases
where name not in ('master', 'tempdb', 'model', 'msdb')

IF OBJECT_ID('tempdb..#tmp_Indexes') IS NOT NULL
	DROP TABLE #tmp_Indexes

DECLARE	@strSQL	VARCHAR(2000)
DECLARE	@IndexName VARCHAR(1000)

CREATE TABLE #tmp_Indexes
(
	DatabaseName	VARCHAR(100),
	IndexName	VARCHAR(1000)
)

SET	@IndexName = 'mst_Employees_IX01' -- You can enter the name of the index here

SET	@strSQL = ' SELECT ''?'', name FROM ?..sysindexes WHERE name LIKE ''%' + @IndexName + '%'' '
			
INSERT	#tmp_Indexes( DatabaseName, IndexName )
EXECUTE sp_MSforeachdb @strSQL

SELECT * FROM #tmp_Indexes

IF OBJECT_ID('tempdb..#tmp_Indexes') IS NOT NULL
	DROP TABLE #tmp_Indexes