Was this page helpful?
Additional feedback?
1500 characters remaining
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