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. |