alter table
create default
create index
create plan*
create procedure
create rule
create schema*
create table
create trigger
create view
drop default
drop index
drop procedure
drop rule
drop table
drop trigger
drop view
grant
installjava*
remove java*
revoke
sp_addalias
sp_addgroup
sp_addmessage
sp_add_qpgroup*
sp_adduser
sp_addtype
sp_bindefault
sp_bindmsg
sp_bindrule
sp_changegroup
sp_chgattribute
sp_commonkey
sp_config_rep_agentsp_dropalias
sp_drop_all_qplans*
sp_dropgroup
sp_dropkey
sp_dropmessage
sp_drop_qpgroup*
sp_droptype
sp_dropuser
sp_export_qpgroup*
sp_foreignkey
sp_import_qpgroup*
sp_primarykeysp_procxmode
sp_recompile
sp_rename
sp_rename_qpgroup*
sp_setrepcol
sp_setrepdefmode
sp_setrepmode
sp_setrepproc
sp_setreptable
sp_unbindefault
sp_unbindmsg
sp_unbindrule
To enable replication of DML and DDL commands, execute sp_reptostandby at the Adaptive Server that manages the active database. The syntax is:
sp_reptostandby dbname[, 'L1' | 'all' | 'none' ]
where dbname is the name of the active database and the keywords L1, all, and none set the level of replication support.
L1 represents the level of replication supported by Adaptive Server version 12.5.
Use the all keyword to make sure that schema replication support is always at the highest level available. For example, to set the schema replication support level to that of the latest Adaptive Server version, log in to Adaptive Server and execute this command at the isql prompt:
sp_reptostandby dbname, 'all'
Then, if the database is upgraded to a later Adaptive Server version with a higher level of replication support, all new features of that version are enabled automatically. Refer to Chapter 5, “Adaptive Server Commands and System Procedures,” in the Replication Server Reference Manual for more information about sp_reptostandbycommand.
