| 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 |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 4ab1b2ae-b6d9-42b7-9b31-98547dbb7f99 | ||
| author | stevestein | ||
| ms.author | sstein |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-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: 1 = Snapshot Agent 2 = Log Reader Agent 3 = Distribution Agent 4 = Merge Agent 9 = Queue Reader Agent |
| type | int | The type of profile: 0 = System1 = Custom |
| description | nvarchar(3000) | The description of the profile. |
| def_profile | bit | Specifies whether this profile is the default for this agent type. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)