MSagent_profiles (Transact-SQL)


Applies To: SQL Server

The MSagent_profiles table contains one row for each defined replication agent profile. This table is stored in the msdb database.

Column nameData typeDescription
profile_idintThe profile ID.
profile_namesysnameThe unique profile name for agent type.
agent_typeintThe type of agent:

 1 = Snapshot Agent

 2 = Log Reader Agent

 3 = Distribution Agent

 4 = Merge Agent

 9 = Queue Reader Agent
typeintThe type of profile:

 0 = System1 = Custom
descriptionnvarchar(3000)The description of the profile.
def_profilebitSpecifies whether this profile is the default for this agent type.

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

Community Additions