none
Transactional Push subcription (Change Syn_Type)

    Question

  • I have created transactional push subscription, one of the major query is as following

    /////////////////////////////////////////////////////////////////////////////////////////

    exec sp_addsubscription @publication = N'TestP', @subscriber = N'VM-2008-81', @destination_db = N'LogDatabase', @subscription_type = N'Push', @sync_type = N'replication support only', @article = N'all', @update_mode = N'queued failover', @subscriber_type = 0;

    /////////////////////////////////////////////////////////////////////////////////////////

    Now I want to change @sync_type = 'automatic' and don't want to re-create

    Please help me to change sync_type of existing subscription

    Thursday, March 08, 2012 10:57 AM

Answers