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

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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!
  • OK thanks I'll take a look at that

    steve
This discussion has been closed.