To turn off data and schema replication, log in to Adaptive Server and enter this command at the isql prompt:
sp_reptostandby dbname,'none'
When replication is turned off, Adaptive Server locks all user tables in exclusive mode and saves information about each of them. This process may take some time if there are a large number of user tables in the database.
Use this procedure only if you are disabling the warm standby application.
If you want to turn off replication for the current isql session
only, use the set replication command. See “Changing replication for the current isql session” for more information. Also,
if the database is marked for replication to use indexes on text, unitext, image,
and rawobject columns, the above command also
drops indexes for replication on tables not explicitly marked for
replication.
