Synchronization script error

gvar369

Hi,

I have a problem with one of the SP's i'm trying to synchronize with another database. I created the SP within a particular schema, but when i click on synchronize, it isn't showing the schema name in the synchronization script. It's showing CREATE PROCEDURE <Procedure_Name> instead of CREATE PROCEDURE <SchemaName>.<Procedure_Name>.
Following is the screenshot of the above mentioned error.


This error is only specific to this SP only, other SP's went through fine.

Let me know if you need any additional information in resolving this issue.

Thanks,
Vijay

James B

Thanks for your post - I've just tried to replicate this here, but no joy so far.
Part of the issue may be that the object in question already exists in the target, but under dbo instead of SOW - on the Owner Mapping tab of "Edit Project", have you mapped SOW to anything on the other side?
What versions of SQL Server are the two databases running on?