SQL Remote User's Guide
SQL Remote Administration
Running the Message Agent
Some Message Agent settings need to be the same throughout an installation, and so should be set before deployment. This section lists the settings that need to be the same.
Maximum message length The maximum message length for SQL Remote messages has a default value of 50K. This is configurable, using the Message Agent -l
option. However, the maximum message length must be the same for each Message Agent in the installation, and may be restricted by operating system memory allocation limits.
Received messages that are longer than the limit are deleted as corrupt messages.
For details of this setting, see The Message Agent.