MSagent_profiles

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.