msagent-profiles-transact-sql.md

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