Sample Header Ad - 728x90

merge replication - change the property pre_creation_command just for one article, is it possible?

0 votes
0 answers
26 views
- merge replication publication - I would like to change the property only for this particular table myTable ,so that it will truncate the table at the subscriber, but I would like to leave all other articles unchanged. is this possible?
TITLE: Publication Properties
------------------------------

Cannot save properties for article 'myTable'.

------------------------------
ADDITIONAL INFORMATION:

Property "pre_creation_command" update with value "Truncate" failed. (Microsoft.SqlServer.Rmo)

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Property 'pre_creation_command' of article 'myTable' cannot be changed.
Changed database context to 'mypublication_DB'. (Microsoft SQL Server, Error: 21416)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-21416-database-engine-error 

------------------------------
BUTTONS:

OK
------------------------------
enter image description here
Asked by Marcello Miorelli (17274 rep)
Jan 27, 2025, 12:58 PM