PORQUE sale este Mensaje al DROPEAR UN INDICE?

[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'