“max_packet_size” variant in SQL Server

Question

I am wondering if there is a SQL Server "version" of the MySQL max_packet_size parameter. Is there a way to configure this setting in SQL Server?

Remus Rusanu · Accepted Answer · 2012-11-05 11:26:54Z

up vote 2 down vote accepted

sp_configure 'network packet size', ...;

But this setting is not the same as MySQL's max_allowed_packet, is more similar to net_buffer_length. SQL Server's maximum request limit is 65,536 * Network Packet Size, which is closer to max_allowed_packet meaning.

edited Nov 5 '12 at 11:26

answered Nov 5 '12 at 11:21

Remus Rusanu
21.1k22357

Thanks for your answer! – Timothy Nov 5 '12 at 15:15

1 Answer