select object_name(object_id), * 
from   sys.sql_modules as sm
where  sm.definition like '%Имя_Индекса%'

SELECT top(100)   OBJECT_NAME(S.[OBJECT_ID]) AS [OBJECT NAME]
       , I.[NAME] AS [INDEX NAME]
       , USER_SEEKS
       , USER_SCANS
       , USER_LOOKUPS
       , USER_UPDATES 
  FROM SYS.DM_DB_INDEX_USAGE_STATS AS S
       INNER JOIN SYS.INDEXES AS I ON I.[OBJECT_ID] = S.[OBJECT_ID] AND I.INDEX_ID = S.INDEX_ID 
       WHERE  S.[OBJECT_ID] = OBJECT_ID('схема.Таблица')