Add new Project Behavior:
"Do not use ALTER to modify stored procedures or views"
When this option is selected, SQL Compare will drop and then create any stored procedures and views that are to be synchronized rather than using the ALTER method. This will create the "if exists() drop..." sql code even if the stored procedure is being added for the first time.
This is similar to scripting stored procedures from Enterprise manager.
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ExampleStoredProcedure]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ExampleStoredProcedure]
CREATE PROCEDURE [dbo].[ExampleStoredProcedure] ...
Please note that this feature request is similar to this previous post:
http://www.red-gate.com/messageboard/vi ... t=2747#top