Contains one row for each defined replication agent profile. This table is stored in the msdb database.
Column name | Data type | Description |
---|---|---|
profile_id | int | Profile ID from the MSagent_profiles table. |
profile_name | sysname | Unique profile name for agent type. |
agent_type | int | Type of agent: 1 = Snapshot Agent 2 = Log Reader Agent 3 = Distribution Agent 4 = Merge Agent |
type | int | Type of profile: 0 = System 1 = Custom |
description | varchar(3000) | Description of the profile. |
def_profile | bit | Specifies whether this profile is the default for this agent type. |