Hi,
I tried to change the subscription property "sync_type" whith a system procedure but I was not able to do it, because sp_changesubscription does not support this property.
Is there any chance to change this property by procedure
So I decided to drop the subscription and define it new with sp_addsubscription. I chose to set this to "replication support only" as the value "none" is depricated based on the online help. Unfortunately using this value results in an error message "only none or automatic is allowed".
How can I set this value now to "replication support only"
I need to set the value to "replication support only" as this value leads into the generation of the stored procedures used for insert, update and deletes.
The purpose behind this, to restart a transactional push replication, doing all the initialization stuff by myself and not with reinitialize subscirption. I would like to decide, if I do the initialisation.
Regards
Nobsay
sync_type parameter in subscription
C3i
Hi Nobsay,
To clarify:
1) You are right in saying that it is not possible to change sync_type via sp_changesubscription.
2) You should be able to specify a sync_type of 'replication support only' or 'initialize from backup' if your publisher is a SQL2005 server.
Hope that helps,
-Raymond
medhat__1
Raymond,
thank you very much for the clarification. It helped a lot!
Regards
Nobsay
Jeroen Vos
Thanks Ramond for your answer but this was a quick shot and not sufficient for me.
So it is NOT possible to change this parameter, right Question to MS: why For every other purpose you have a sp_change_xxx procedure, unfortunately not for "sync_type".
The other question is still open:
How can I set "replication support only" if sp_addsubscription allows only "none" or "automatic"
Regards and thanks in advance for your help
Nobsay
D-Swat
Hi nobsay,
You can drop and re-add the subscription with the new sync_type value.
Hope that helps.