The MSagentparameterlist table contains replication agent parameter information and is used to specify the parameters that can be set for a given agent type. This table is stored in the msdb database.
|
Column name
|
Data type
|
Description
|
|---|
|
agent_type
|
tinyint
|
The type of agent:
1 = Snapshot Agent.
2 = Log Reader Agent.
3 = Distribution Agent.
4 = Merge Agent.
9 = Queue Reader Agent.
|
|
parameter_name
|
sysname
|
The name of a valid agent parameter.
|
|
default_value
|
nvarchar(4000)
|
The default value for the agent parameter, where NULL indicates that no such value exists.
|
|
min_value
|
int
|
Sets a lower bound for the agent parameter, where NULL indicates no lower bound.
|
|
max_value
|
int
|
Sets an upper bound for the agent parameter, where NULL indicates no upper bound.
|
See Also