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.