Jack Corbett (11/12/2014)
Yes, since the corruption is in an non-clustered index you can either REBUILD the index or explicitly drop and recreate it.
You can never rebuild to fix corruption in a NC index, because the rebuild process reads the old index. Drop and recreate, yes. Rebuild, no.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability