Purpose

The purpose of this article is to teach you the process of configuring packet size in Microsoft SQL Server 2000.

To Configure Packet Size

Use the network packet size option to set the packet size (in bytes) used across the entire network. Packets are the fixed-size chunks of data that transfer requests and results between clients and servers. The default packet size set by Microsoft SQL Server is 4,096 bytes.

Following steps describe you the process of configuring packet size:

1. Click Start, go to Programs, then go to Microsoft SQL Server, and then click Enterprise Manager.

2. Click Tools on menu bar and then click Options.

3. Enter a value in bytes for Packet size (bytes): option.

4. Click OK.