>I'm not using a stored connection but using the sqlstringconnect.
>
>The haven't changed the default packet size on sql server so it is at 4096. Does that mean that every packet will be 4096 even if it doesn't need the whole 4096 or just that is the maximum packet size?
>
Kirk,
From SQL Server Books On-Line:
"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 4096 bytes. If an application does bulk copy operations, or sends or receives large amounts of text or image data, a packet size larger than the default may improve efficiency because it results in fewer network reads and writes. If an application sends and receives small amounts of information, you can set the packet size to 512 bytes, which is sufficient for most data transfers."
George
Ubi caritas et amor, deus ibi est