[EMAIL PROTECTED] wrote:
The sp_configure option is dynamic, but only affects future connections. It
is an upper limit, and the client has to specifically request the larger
packet size to get it. Otherwise the default 512 byte packet size is used.
Michael
In addition to setting the configuration param for max packet size, you
also need to allocate a number of bytes to the pool of memory from which
the larger packets are drawn. This pool of memory is addressed by the
sp_configure parameter 'additional network memory'. There is a formula
to caluclate the actual amount required based on the number of
connections and the packet sizes required.
Regards,
Chuck