Network Buffer

[RG]

We have a vb6 application that among other things queries sql server 2005 db
over lan. On the client side, where do I control the size of network buffer?

Thanks in advance

[William Vaughn (MVP)]

What are you trying to accomplish by setting the size of the network buffer?
What problem are you having? Are you concerned with performance, security,
locks or what?

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com http://betav.com/blog/billva
____________________________________________________________________________________________

"RG" <R...@discussions.microsoft.com> wrote in message
news:0D626914-7291-4927...@microsoft.com...

[Erland Sommarskog]

RG (R...@discussions.microsoft.com) writes:
> We have a vb6 application that among other things queries sql server
> 2005 db over lan. On the client side, where do I control the size of
> network buffer?

In the connection string with the PacketSize keyword. The default is
4096, and as Bill says there is probably little reason to meddle with it.
But you can set it to 256 to see the effect - things will be slower!

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx