Hello jabell, Rafael,
I will elaborate the steps how to reproduce the issue.
1). In the SQL Server, I have a stored procedure:
@param1 int= 0,
SELECT @param1, @param2
I create a database project in the Visual Studio, and on the database project I did “Import Database Objects and Settings…”
Now the database project has a stored procedure which has two parameters.
2). In the source database, I modify the stored procedure:
@param1 int= 0
Note: Now the stored procedure has only one parameter.
3). Do a schema compare, the database as the source schema and the database project as the target schema. When I select the ‘Skip’ and
do ‘Write Update’, the issue occurs. I have the parameter @param2 comment out.
@param1int= 0,/*@param2 int*/
If you want to synchronize your stored procedure, you just don’t select the ‘Skip’ option, and do ‘Write updates’ and
the @param2 will be deleted in the database project instead of commented out. If you don’t want to synchronize your stored procedure, just as I mentioned last reply, ignore the Stored Procedure in the Schema Compare Options.
Please remember to mark the replies as answers if they help and unmark them if they provide no help