Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


SQL Server 2000

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft