Hi all,
Just made a discovery today. If you run the Index Tuning wizard and it "forgets" to clean up statistics, you're left with what appear to be clustered indexes that start with the letters "hind" (for Hypothetical Index, I imagine).
This can cause SQL Compare to behave as though the table has multiple clustered indexes and ruin any syncs (SQL Server rejects multiple indexes).
Knowledge Base description:
http://support.microsoft.com/kb/290414
Just made a discovery today. If you run the Index Tuning wizard and it "forgets" to clean up statistics, you're left with what appear to be clustered indexes that start with the letters "hind" (for Hypothetical Index, I imagine).
This can cause SQL Compare to behave as though the table has multiple clustered indexes and ruin any syncs (SQL Server rejects multiple indexes).
Knowledge Base description:
http://support.microsoft.com/kb/290414