Why can't this stored procedure be called? (Fre eTDS_JDBC and jtds)

Lowden, James K LowdenJK at bernstein.com
Mon Sep 10 13:22:13 EDT 2001


I think Mr. Lewis is on to something.  I happen to have the 6.5 docs here:

"In SQL Server, SET NOCOUNT ON eliminates the sending of DONE_IN_PROC
messages to the client for each statement in a stored procedure. For stored
procedures that contain several statements that do not return much actual
data, this can provide a significant performance boost because network
traffic is greatly reduced."

If you want to set this off permanently, see sp_configure and @@options.  

--jkl

-----Original Message-----
From: brlewis at alum.mit.edu [mailto:brlewis at alum.mit.edu]
Sent: September 10, 2001 12:17 PM
To: TDS Development Group
Subject: [freetds] Re: Why can't this stored procedure be called?
(FreeTDS_JDBC and jtds)


"Anton van Straaten" <anton at appsolutions.com> writes:

> 	create procedure spTestExec as
> 		create table #tmp ( Result varchar(50) )
> 		insert #tmp execute spTestExec2
> 		select * from #tmp

You're going against 6.5 and still aren't in the habit of putting "set
nocount on" at the beginning of every stored procedure?  I can hardly
get anything to work without it.

-- 
Bruce R. Lewis				http://brl.sourceforge.net/

---
You are currently subscribed to freetds as: [LowdenJK at bernstein.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')



More information about the FreeTDS mailing list