Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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