MSagent_profiles (Transact-SQL)
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. |