SQL Server Performance

Replication By Script

Discussion in 'General DBA Questions' started by dineshasanka, Feb 23, 2007.

  1. dineshasanka Moderator

    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/

Share This Page