MSagent_profiles (Transact-SQL)

Applies to: SQL Server

The MSagent_profiles table contains one row for each defined replication agent profile. This table is stored in the msdb database on the Distributor.

Column name	Data type	Description
profile_id	int	The profile ID.
profile_name	sysname	The unique profile name for agent type.
agent_type	int	The type of agent: 1 = Snapshot Agent 2 = Log Reader Agent 3 = Distribution Agent 4 = Merge Agent 9 = Queue Reader Agent
type	int	The type of profile: 0 = System 1 = Custom
description	nvarchar(3000)	The description of the profile.
def_profile	bit	Specifies whether this profile is the default for this agent type.

Related content

• Replication Tables (Transact-SQL)
• Replication Views (Transact-SQL)