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

Item has already been added...

elwooselwoos Posts: 8
edited April 29, 2005 7:41PM in SQL Compare Previous Versions
I am getting an error:-

Item has already been added. Key in dictionary "Stored Procedure.[dbo].[Mysproc]" Key being added:"Stored Procedure.[dbo].[Mysproc]"

When comparing a snapshot from SQL Server 7 to a 2000 database. If I don't use a snapshot I don't get the error.

Any suggestions as to what is happening?

thanks

steve

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Steve,

    Good question. If the snapshot was produced with the 'treat items as case sensitive' and then the comparison was done against a live database that's being compared case-insensitively, this error will occur. It will probably work again if you turn on the 'treat items as case-sensitive' option once again, but keep in mind that any differences in case in your object names will be flagged as a difference!
  • Options
    OK thanks I'll take a look at that

    steve
This discussion has been closed.