Rebuild Index Fails, need insight

[digitalox]

All efforts to rebuild indexes fails. Not with an error, but they still show high fragmentation.

The environment:
SQL Server 2005 in 2000 compatibility mode
non-clustered indexes on tables that have clustered indexes with unique constraint

Tried so far:
Rebuild, reorganize, manual drop and recreate, setting the db in 2005 mode

This only seems to happen on the tables that also have the clustered index with a unique contraint ( which seem to defrag fine on said tables).

I haven't seen this before, can anyone shed some light on it?

Thanks,
Scott

[sleepydog3]

DBCC SHOWCONTIG

[HTML]http://msdn2.microsoft .com/en-us/library/ms175008.aspx[/HTML]

Have you ran DBCC INDEXDEFRAG?

[HTML]http://msdn2.microsoft .com/en-us/library/ms177571.aspx[/HTML]

sys.dm_db_index _physical_stats

[HTML]http://msdn2.microsoft .com/en-us/library/ms188917.aspx[/HTML]

If i understand you question these should help.