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