What are the challenges you face when working across database platforms? Take the survey
Options

"Hind" Hypothetical Indexes Appear as Clustered

rhudsonrhudson Posts: 2
edited June 28, 2007 10:36AM in SQL Compare Previous Versions
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

Comments

  • Options
    Rhudson,

    We are looking into this issue at the moment, and hopefully will include it in a point release in the near future.

    Regards,

    Jonathan
    Jonathan Watts

    -Project Manager
    -Red Gate Software Ltd
Sign In or Register to comment.