---
title: "MSagent_profiles (Transact-SQL) | Microsoft Docs"
ms.custom: ""
ms.date: "03/06/2017"
ms.prod: sql
ms.prod_service: "database-engine"
ms.reviewer: ""
ms.technology: replication
ms.topic: "language-reference"
f1_keywords: 
  - "MSagent_profiles"
  - "MSagent_profiles_TSQL"
dev_langs: 
  - "TSQL"
helpviewer_keywords: 
  - "MSagent_profiles system table"
ms.assetid: 4ab1b2ae-b6d9-42b7-9b31-98547dbb7f99
author: stevestein
ms.author: sstein
---
# MSagent_profiles (Transact-SQL)
[!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md)]

  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**|The profile ID.|  
|**profile_name**|**sysname**|The unique profile name for agent type.|  
|**agent_type**|**int**|The type of agent:<br /><br /> **1** = Snapshot Agent<br /><br /> **2** = Log Reader Agent<br /><br /> **3** = Distribution Agent<br /><br /> **4** = Merge Agent<br /><br /> **9** = Queue Reader Agent|  
|**type**|**int**|The type of profile:<br /><br /> **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.|  
  
## See Also  
 [Replication Tables &#40;Transact-SQL&#41;](../../relational-databases/system-tables/replication-tables-transact-sql.md)   
 [Replication Views &#40;Transact-SQL&#41;](../../relational-databases/system-views/replication-views-transact-sql.md)