A duplicate definition was found for the user 'username'
Agustin890831
Posts: 2 New member
in SQL Compare
Hi, i have this problem when i'm going to make a commit or get latest with the source control, after showme the same error when i make the link to the repository. Someone has seen this error and knows its solution:
A duplicate definition was found for the user 'username'
Ensure that case sensitivity options are set correctly and all object creation scripts are valid.If the problem persists, contact Redgate support.
Greetings and thanks.
Tagged:
Best Answer
-
Eddie D
Posts: 1,803 Rose Gold 5
Hi Agustin890831
Thank you for your forum post and sorry that you have encountered a problem. You posted a SQL Source Control question into the SQL Compare forum.
In my experience, the duplicate definition error may occur for the following two reasons:- You are working with a database that is case sensitive but the case sensitivity options in comparison options is not enabled. To enable the option, please use the link below for advice on how to change the SQL Source Control comparison options: https://documentation.red-gate.com/soc6/configuring/change-the-comparison-options
- The source control repository has been modified manually outside of SQL Source Control and a script for the same object appears to be listed twice. SQL Source Control does not like the repository being editied outside of using the tool and it is not recommended that you perform this action.
Many Thanks
Eddie
