FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

On Thu, 2004-12-02 at 17:25, Lowden, James K wrote:
> I came across the following in Microsoft's documentation.  Something to
> keep in mind if we ever encounter DONE-token problems again.  
> 
> "SET NOCOUNT ON eliminates the sending of DONE_IN_PROC messages to the
> client for each statement in a stored procedure."

Note that Sybase will let you configure this - see dbcc
tune(doneinproc). Turning off "doneinproc" is a frequent network IO
optimization technique.

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
mpeppler AT peppler.org                       http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or 
long term contract positions - http://www.peppler.org/resume.html