|
The different publication types described above can be combined. A single publication can publish a subset of columns from a set of tables and use a WHERE clause to select a set of rows to be replicated.
DBA authority is required to create and drop publications.
Publications can be altered only by the DBA or the publication's owner.
Altering publications in a running SQL Remote setup is likely to cause replication errors and can lead to loss of data in the replication system unless carried out with care.
Views cannot be included in publications.
Stored procedures cannot be included in publications. For a discussion of how SQL Remote replicates procedures and triggers, see Replication of procedures.