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
Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views
Other Resources
Integration Services Tables
Backup and Restore Tables
Log Shipping Tables