Quote:
Drop the index and recreate it.


An extremely similar question just came up here, only with default/non-default collation orders.

Apparently there's a DBCC command that'll cause it to rebuild existing indexes.
_________________________
-- roger