A duplicate definition was found for the stored procedure ...

Jens89

Hi,

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. 

DanC

Hi @Jens89

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