Enables or disables RepAgent thread integration in the Adaptive Server.
sp_configure 'enable rep agent threads'[, 1 | 0]
Enables RepAgent integration for the data server.
Disables RepAgent integration for the data server.
Use sp_configure 'enable rep agent threads' to enable RepAgent for Adaptive Server version 12.0 or later databases.
Use sp_configure 'enable rep agent threads' without options to display the current value, default value, and most recently changed value.
Enable RepAgent in this order:
sp_addserver – identifies the Adaptive Server for RepAgent. You need to do this only once.
sp_configure 'enable rep agent threads' – enables the data server for RepAgent. You need to do this only once.
sp_config_rep_agent – enables the database for RepAgent.
Refer to the Adaptive Server Enterprise Reference Manual for more information about sp_addserver.
sp_configure requires “sa” or “sso” permission to modify configuration parameters.
Anyone can execute sp_configure to display information about parameters and their values.
sp_config_rep_agent and more information about sp_configure in the Adaptive Server Enterprise Reference Manual.
