I have created transactional push subscription, one of the major query is as following
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
We don't have an option for changing this property using sp_changesubscription.
Ashwin and Hilary offer up some workarounds in this thread here:
Brandon Williams (blog |
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?