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
------------------------------

Asked by Marcello Miorelli
(17274 rep)
Jan 27, 2025, 12:58 PM