How to create a replication agent profile (Transact-SQL)

How to Install SQL Server 2000

How To

How to create a replication agent profile (Transact-SQL)

To create a replication agent profile.

  1. Execute sp_add_agent_profile.

  2. Execute sp_add_agent_parameter.

To set the default profile for a type of replication agent

  1. Execute sp_update_agent_profile.

  2. Execute sp_help_agent_profile.

  3. Execute sp_help_agent_parameter.

To view or modify a replication agent profile

  1. Execute sp_help_agent_profile.

  2. Execute sp_help_agent_parameter.

  3. Execute sp_update_agent_profile.

To delete a replication agent profile

  • Execute sp_drop_agent_profile.