MSagent_profiles (T-SQL)

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 from the MSagent_profiles table.
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
type int Type of profile:
0 = System
1 = Custom
description varchar(3000) Description of the profile.
def_profile bit Specifies whether this profile is the default for this agent type.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.