Cita:
Iniciado por iislas 
Espero y no me digas que es para SQL Server 2000 (ja), esta seria la forma de verificar un index en 2005 y superior
SELECT t.name AS [Table Name], i.name AS [Index Name], i.type_desc,
i.data_space_id, f.name AS [Filegroup Name]
FROM sys.indexes AS i
JOIN sys.filegroups AS f ON i.data_space_id = f.data_space_id
JOIN sys.tables as t ON i.object_id = t.object_id
AND i.object_id = OBJECT_ID(N'Schema.tableName','U')
ADN i.name = 'idx_NameOfIndex'
jajaja, si gran "sensei"... efectivamente se trata de un sqlserver 2000, me sale esto: Invalid object name 'sys.indexes'.
