Comments
1 comment
-
Hi @...
Usually in this case, there's a duplicate create statement somewhere in the folder for the object
SQL Compare will read all objects in the directory you point at and won't discriminate, so if it finds a duplicate statement it will flag it
I have an article here that should help for troubleshooting: Duplicate definition troubleshooting in SQL Source Control
Add comment
Please sign in to leave a comment.
When running SQL compare I recently got the issue that a duplicate definition was found for a stored procedure.
Link to database where the stored procedures are:
C:\git\mydatabase\db\mydatabase\Stored Procedures
I have a decommissioned folder like this where the stored procedure resides:
C:\git\mydatabase\db\mydatabase\Decomissioned
Up until recently, there was no problem. When I remove the SP from the decomissioned folder, another one is causing the problem. If I remove all of them, there is no error anymore. To be clear, there is NO duplication going on. This folder is the only place where the SP exists. I double checked this.