MSagentparameterlist (Transact-SQL)

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

Reference

Replication Views (Transact-SQL)

Concepts

Replication Tables (Transact-SQL)