NetPacketSize Property
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The NetPacketSize property specifies the size of a network packet used to transmit a block of data from a client and to an instance of Microsoft SQL Server
Syntax
object
.NetPacketSize [= value]
Parts
object
An expression that evaluates to an object in the Applies To listvalue
A long integer value from 128 through 65535
Data Type
Long
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetNetPacketSize(LPLONG pRetVal);
HRESULT SetNetPacketSize(long NewValue);
Remarks
SQL Server uses a default network packet size of 4096 bytes. The size of a network packet may be limited by the Net-Library used for the client connection.
Setting NetPacketSize to 0 enables the default size, 4096 bytes.