msagent-profiles-transact-sql.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs
MSagent_profiles (Transact-SQL)	The MSagent_profiles table contains one row for each defined replication agent profile.	VanMSFT	vanto	randolphwest	10/15/2024	sql	replication	reference	MSagent_profiles MSagent_profiles_TSQL	MSagent_profiles system table	TSQL

MSagent_profiles (Transact-SQL)

[!INCLUDE 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)