The MSagent_profiles table 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. |
| 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
9 = Queue Reader Agent |
| type | int | Type of profile:
0 = System
1 = Custom |
| description | nvarchar(3000) | Description of the profile. |
| def_profile | bit | Specifies whether this profile is the default for this agent type. |