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

Item has already been added...

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
elwoos
0

Comments

2 comments

Sort by
  • Brian Donahue
    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!
    Brian Donahue
    0
  • elwoos
    OK thanks I'll take a look at that

    steve
    elwoos
    0

Add comment

Please sign in to leave a comment.