Use sp_setreptable to mark individual tables to not be replicated, regardless of the database setting.
sp_setreptable [tabname [, 'true' | 'false' | 'never']]
true – explicitly marks the table for replication, regardless of whether the database is marked for replication or not.
false – disables the replication status on a table that has previously been enabled for replication.
never – disables replication on the table, regardless of the database replication setting.
Example 1 To disable replication on table tnever in database pdb, use:
sp_reptostandby pdb, 'ALL' go sp_setreptable tnever, 'never' go
In warm standby configurations, all tables are replicated when sp_reptostandby has been set to ALL or L1. To avoid replication on specific tables, mark the table to never replicate. Any modification performed on it is therefore not marked as replicated in the transaction log.
| Copyright © 2009. Sybase Inc. All rights reserved. |
|
|