Before you can delete an ASE Replicator database connection, you must delete all publications or subscriptions associated with that database connection.
You delete primary database connections and replicate database connections separately for each database.
To delete a primary database connection
Use sp_dropprimaryconn with the following syntax:
sp_dropprimaryconn "conn_name"
where conn_name is the connection name in the form ds.db.
To delete a replicate database connection
Use sp_dropreplicateconn with the following syntax:
sp_dropreplicateconn "conn_name"
where conn_name is the connection name in the form ds.db.
