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