MSagent_profiles (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

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

ADD
Show:
© 2016 Microsoft