| title | MSagent_profiles (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/06/2017 | ||
| ms.prod | sql-server-2016 | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| applies_to |
|
||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 4ab1b2ae-b6d9-42b7-9b31-98547dbb7f99 | ||
| caps.latest.revision | 23 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!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)