Redigera

Dela via

MSagent_profiles (Transact-SQL)

  • Artikel

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 on the Distributor.

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 = System
1 = Custom
description nvarchar(3000) The description of the profile.
def_profile bit Specifies whether this profile is the default for this agent type.

Related content