Sign in
 
Home20122008 R2200820052000LibraryForums
Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.
SQL Server >
> 
> 
Transactional Push subcription (Change Syn_Type)

Answered Transactional Push subcription (Change Syn_Type)

  • Thursday, March 08, 2012 10:57 AM
     
     
    Sign In to Vote
    0

    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

     

All Replies