Options
Item has already been added...
elwoos
Posts: 8
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
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
This discussion has been closed.
Comments
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!
steve