MSagent_profiles (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

See Also

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)