| title | MSagentparameterlist (Transact-SQL) | ||
|---|---|---|---|
| description | MSagentparameterlist (Transact-SQL) | ||
| author | VanMSFT | ||
| ms.author | vanto | ||
| ms.date | 03/27/2026 | ||
| ms.service | sql | ||
| ms.subservice | replication | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!INCLUDE SQL Server]
The MSagentparameterlist table contains replication agent parameter information and specifies the parameters that you can set for a given agent type. This table is stored in the msdb database.
Important
Don't directly modify system tables such as MSagentparameterlist. To change replication agent parameters like CommitBatchSize, use sp_change_agent_parameter (Transact-SQL) or configure agent profiles in SQL Server Management Studio.
| 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. |