Help! with error "An item with the same key has already been added" on .NET site

Server Side Components
#1

I have a site that has been working. It suddenly started giving me the following error ‘An item with the same key has already been added’ on the SQL database. I have researched the error and the cause it a table or view with the same column names. I have many views and tables and have not found the error. Has anyone had this problem and is there a way to check for the table causing the error. I don’t see it in the logs or the error message. I am REALLY stuck on this. Any help would be appreciated.

Thanks!
Ken

#2

Probably not the column names but a value in a primary ID field which must be unique.
If so, it will likely stem from an update query where you are erroneously manually inserting a value into an auto increment field causing a duplicate