How can we help you today? How can we help you today?

Index Out of Range, with the latest version?

All of a sudden I started getting an Index Out of Range error when doing a SQL Compare. Does anyone have any idea how I might be able to get past this?

I just did an update yesterday, to 13.6.7.8464. Before that everything worked fine, and I've never come across this error before. 


JohnES
0

Comments

5 comments

Sort by
  • Russell D
    Its possible there is a problem in the parser, did you send in an error report? Can you share some snapshots?
    Russell D
    0
  • JohnES
    I just encountered this issue again. This time I sent a report, and referenced the title of this thread in the body of the problem description.
    JohnES
    0
  • Jessica R
    Hi @JohnES,

    Just updating the forum post here with the progress from the ticket. This issue appears to happen when     you have the following:

    1. SET ANSI_NULLS ON at the end of a proc (with no preceding GO statement)
    2. "Ignore SET QUOTED_IDENTIFIER and SET ANSI_NULLS statements" and "Add WITH ENCRYPTION" are both enabled
    3. "Ignore WITH ENCRYPTION" disabled

    We are looking into this from our side.

    Thanks again for your help, John!
    Jessica R
    0
  • JohnES
    You're Welcome Jessica. 

    Thank You for your help sorting this out.
    JohnES
    0
  • Jessica R
    Hi @JohnES !

    This issue is now resolved in the latest frequent release update, SQL Compare 13.6.8.8602. You can get this from Help>Check for updates (you need to make sure Help>Configure frequent updates is turned on).
    Jessica R
    0

Add comment

Please sign in to leave a comment.