In the documentation, Under CREATE PUBLICATION under parameters
publish (string)
This parameter determines which DML operations will be published by the new publication to the
subscribers.The value is comma-separated list of operations. The default is to publish all actions, and so the default
valuefor this option is ‘insert, update, delete, truncate’.
From what I’ve seen, truncate is not set to published by default. I’m looking at a server now with 4 publications on
it,and none has truncate set to true. One of these I created, and I know I didn’t set any values. All the other values
areset, but not truncate.
I don’t know if this was intentional in the code or an oversight, but documentation is incorrect currently. Also, the
linebefore, beginning with “The value is comma-separated…”, could use a little work as well. Maybe just an “a” between
“is”and “comma-separated”.
—
Jay
Sent from my iPad