Support for Adaptive Server Commands and System Procedures

Support is extended for the replication of several Adaptive Server commands and system procedures.

DDL commands and system procedures supported for replication:
  • alter login
  • alter login profile
  • alter...modify owner – Replication Server treats tables with different owners as different tables. You must make the relevant change to the table replication definitions if you use alter...modify owner to change the owner for an Adaptive Server replicated table. See Replication Server Administration Guide Volume 1 > Manage Replicated Tables > Modify Replication Definitions > Alter Replication Definitions > Changes You Can Make to the Replication Definition > Changing Table Owner.
  • create login
  • create login profile
  • drop login
  • drop login profile
  • sp_hidetext
System procedures supported for master database replication:
  • sp_addexternlogin
  • sp_dropexternlogin
  • sp_maplogin
  • sp_addremotelogin
  • sp_dropremotelogin
  • sp_addserver
  • sp_dropserver

See Replication Server > Reference Manual > Adaptive Server Commands and System Procedures > sp_reptostandby > Supported DDL Commands and System Procedures.

Parent topic: Enhancements to Adaptive Server Replication Support