Disabling replication

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.

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