Transact-SQL Reference

MSagent_profiles

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 Profile ID.
profile_name sysname Unique profile name for agent type.
agent_type int Type of agent:

1 = Snapshot Agent
2 = Log Reader Agent
3 = Distribution Agent
4 = Merge Agent
9 = Queue Reader Agent

type int Type of profile:

0 = System
1 = Custom

description nvarchar(3000) Description of the profile.
def_profile bit Specifies whether this profile is the default for this agent type.