Create the release, also did not create a subscription! Released by the object or aa this table in the table, but we may not be able to delete will delete! When publishing created to delete, aa table can be deleted!
Quote: the value provided for the parameter @ procmapid is invalid, please specify the valid parameter values,
The transaction ended in the trigger, the batch has been suspended, (.net SqlClient Data Provider)

CodePudding user response:

Can query the sys. Tables to confirm whether is marked as duplicate
Is_replicated
Bit
1=use snapshot copy or transaction replication table,

Has_replication_filter
Bit
1=table with copy filter,

Is_merge_published
Bit
1=using merge replication table,

CodePudding user response:

Has examined the is_replicated 1 released my watch is a few, the other is zero! Publish-subscribe no problem, but as long as to create a release, all the tables in the database will be deleted

CodePudding user response:

Please perform
Select * from sys. Triggers the where parent_class=0 and name=N 'tr_MStran_droptable'
See if you can check the database triggers tr_MStran_droptable, if there is, first remove the trigger try again after delete table.
Drop the trigger [tr_MStran_droptable] on the database