Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

nocount has no affect?

3 posts in Windows NT Last posting was on 1997-12-11 05:22:30.0Z
George Zicterman Posted on 1997-12-10 20:58:11.0Z
From: "George Zicterman" <g.zicterman@worldnet.att.net>
Subject: nocount has no affect?
Date: Wed, 10 Dec 1997 14:58:11 -0600
Lines: 14
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Message-ID: <Y1YsYCUB9GA.167@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5361
Article PK: 1081437

We have several stored procedures that update several thousand records at a
time and want to make them less sensitive to network traffic. It seems that
many types of statements executed within the body of the sp cause an
unwanted message be sent to the client. I am under the impression that
setting the nocount on at the beginning of the sp will suppress these
messages. Using the monitor client and repeated testing shows no change in
the amount of messages sent to the client.

Any thoughts on this subject would be greatly appreciated.


Gary Kuever Posted on 1997-12-11 05:22:30.0Z
From: "Gary Kuever" <gkuever@ix.netcom.com>
References: <Y1YsYCUB9GA.167@forums.powersoft.com>
Subject: Re: nocount has no affect?
Date: Wed, 10 Dec 1997 21:22:30 -0800
Lines: 21
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Message-ID: <R8gIIveB9GA.141@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5352
Article PK: 1081431

Try DBCC TRACEON(260) on a test server. If it works, you can put it into
your runserver file and make it permanent.
Last time I tried it on a PB project, it caused some problems with the
existing PB app and it was decided not to recode and we dropped it. But it
did make a difference on a WAN connection. That was 2 years ago so it may be
better now too.

Good luck!
Gary

>Any thoughts on this subject would be greatly appreciated.
>
>
>
>
>


Mark A. Parsons Posted on 1997-12-11 02:32:39.0Z
Message-ID: <348F50C7.6400@compuserve.com>
Date: Wed, 10 Dec 1997 21:32:39 -0500
From: "Mark A. Parsons" <Iron_Horse@compuserve.com>
Reply-To: Iron_Horse@compuserve.com
Organization: Iron Horse, Inc.
X-Mailer: Mozilla 3.01 (Win95; I)
MIME-Version: 1.0
Subject: Re: nocount has no affect?
References: <Y1YsYCUB9GA.167@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 31
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5354
Article PK: 1081433

'set nocount on' just suppresses the messages like:

(5 rows affected)

I seem to recall that there was a client side setting called something
like ... DONEINPROC ??? ... John McVicker's the one that knew about
this (maybe he'll jump in if he's around). Can you do a search in your
client manuals (SybBooks?) for the DONEINPROC (or substrings of this)?
I'm pretty sure that disabling this cut down quite a bit on the
'background' commo between the client and stored proc executions ... not
sure if there were any drawbacks to turning this off though ... ???

Mark Parsons
Iron Horse, Inc

George Zicterman wrote:
>
> We have several stored procedures that update several thousand records at a
> time and want to make them less sensitive to network traffic. It seems that
> many types of statements executed within the body of the sp cause an
> unwanted message be sent to the client. I am under the impression that
> setting the nocount on at the beginning of the sp will suppress these
> messages. Using the monitor client and repeated testing shows no change in
> the amount of messages sent to the client.
>
> Any thoughts on this subject would be greatly appreciated.