"Hind" Hypothetical Indexes Appear as Clustered
rhudson
Posts: 2
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
Comments
We are looking into this issue at the moment, and hopefully will include it in a point release in the near future.
Regards,
Jonathan
-Project Manager
-Red Gate Software Ltd