MSagentparameterlist (Transact-SQL)

Applies to: yesSQL Server (all supported versions)

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

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)