• Article

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 list

  • value
    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.

Applies To:

SQLServer Object