This is SQL Server 2000 and SP4 I have created Merge Replication I have a push subscriber with syncronization set on Continous. I created script on this. then I drop the replication. Ran the earlier script again. I found that syncronisation frequency has changed to Daily one hour!! I examine the queries I found that that is a falut in the generate scripts. Script was like this. exec sp_addmergesubscription @publication = N'Mypub', @subscriber = N'PC2', @subscriber_db = N'Pupub', @subscription_type = N'push', @subscriber_type = N'local', @subscription_priority = 0.000000, @sync_type = N'none', @frequency_type = 4, @frequency_interval = 1, @frequency_relative_interval = 1, @frequency_recurrence_factor = 0, @frequency_subday = 8, @frequency_subday_interval = 1, @active_start_date = 0, @active_end_date = 0, @active_start_time_of_day = 0, @active_end_time_of_day = 235959, @enabled_for_syncmgr = N'false', @offloadagent = 0, @use_interactive_resolver = N'false' GO But it should be exec sp_addmergesubscription @publication = N'Mypub', @subscriber = N'PC2', @subscriber_db = N'Pupub', @subscription_type = N'push', @subscriber_type = N'local', @subscription_priority = 0.000000, @sync_type = N'none', @frequency_type = 64, @frequency_interval = 1, @frequency_relative_interval = 1, @frequency_recurrence_factor = 0, @frequency_subday = 8, @frequency_subday_interval = 1, @active_start_date = 0, @active_end_date = 0, @active_start_time_of_day = 0, @active_end_time_of_day = 235959, @enabled_for_syncmgr = N'false', @offloadagent = 0, @use_interactive_resolver = N'false' GO Error was in @frequency_type. What may have gone wrong ---------------------------------------- Contributing Editor, Writer & Forums Moderator http://www.SQL-Server-Performance.Com Visit my Blog at http://dineshasanka.spaces.live.com/
