how not to INITIALIZE EVERYTHING when scripting out publication

Last Post 23 Jul 2004 04:30 PM by Ali baba_SQL. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Ali baba_SQL
New Member
New Member

--
23 Jul 2004 08:35 AM
Hi again,


When I script out the replication on the publisher (Tools->Replication->Generate SQL) the script defaults to initializing all when it's run.


There is some flag that specifies that, does anyone know how to change the script to NOT initialize everything?



Thanks
Ali baba_SQL
New Member
New Member

--
23 Jul 2004 09:57 AM
I guess the question is how to modify the script in preview page.

There is a paremeter 'automatic', but I am not sure if that's the right one, or what's the right syntax.

Thanks
Ali baba_SQL
New Member
New Member

--
23 Jul 2004 04:30 PM
YEAP, IT SEEMS LIKE @sync_type IN sp_addsubscription IS THE COULPRIT.

Should be set to 'none' not to initialize, if i'm reading this right.

Thanks
You are not authorized to post a reply.

Acceptable Use Policy