Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Enabling pre_creation_command option requires re-initialization


View products that this article applies to.

Summary

When enabling @pre_creation_commandoption of stored procedure sp_changemergearticle, you must specify a value of 1 force_invalidate_snapshot parameter.

↑ Back to the top


More Information

The following SQL Server Books Online does not list this parameter as one of the parameters that requires subscription re-initialization when changed:
The following error is reported if you do not specify @force_reinit_subscription=1 when using pre_creation_command parameter in sp_changemergearticle stored procedure.

Msg 20608, Level 16, State 1, Procedure sp_changemergearticle, Line 395
Cannot make the change because there are active subscriptions. Set @force_reinit_subscription to 1 to force the change and reinitialize the active subscriptions


↑ Back to the top


Keywords: kbsql2005repl, kb

↑ Back to the top

Article Info
Article ID : 2753868
Revision : 3
Created on : 11/20/2019
Published on : 11/20/2019
Exists online : False
Views : 487