sp_mpxcfg_<servername> procedure

Function

Sets up query server named servername for SQL Remote replication.

Syntax

call “DBA”.sp_mpxcfg_<servername>( ‘ ‘ )

Description

Sybase IQ calls this procedure when synchronizing query servers. This procedure in turn runs specified procedure or procedures on the named query server. When finished, this procedure returns the following message in the server log: Query server auto-configuration complete. If the query server is already configured or if you run sp_mpxcfg_servername on a write server, the procedure does nothing.

Permissions

Must have DBA authority.