Disable Replication

Use sp_reptostandby with the none option to turn off data and schema replication.

Log in to Adaptive Server and at the isql prompt, enter:
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.

Note: To turn off replication only for the current isql session, use the set replication command.

Also, if the database is marked for replication to use indexes on text, unitext, image, and rawobject columns, sp_reptostandby dbname, 'none' also drops indexes for replication on tables not explicitly marked for replication.

Related concepts
Change Replication for the Current isql Session