• You can generate the SQL to look for the index you have in each of your databases by using something like this:

    select 'select *

    from ' + name + '.sys.indexes i

    where i.name = ''typeYourIndexNameHere'''

    from master.sys.databases

    where name not in ('master', 'tempdb', 'model', 'msdb')

    Might save you a little bit of time.