Default setting for NOCOUNT?
From: Paul Ritchie (Paul.Ritchie_at_REMOVEpayglobalREMOVE.comREMOVE)
Date: 08/03/04
- Next message: Steve Kass: "Re: Query Excel"
- Previous message: Steve Kass: "Re: Comprable technique to Yukon's "WITH", in 2000?"
- Next in thread: Paul Ritchie: "Re: Default setting for NOCOUNT?"
- Reply: Paul Ritchie: "Re: Default setting for NOCOUNT?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 4 Aug 2004 09:57:30 +1200
Is it possible to set a default value for NOCOUNT?
I have collegues that have assumed that it always defaults to OFF, however
clients seem to insist they have it always set ON on there servers. However
I can't seem to find where this can be set other than running the SET
NOCOUNT command in the connection.
(Unfortunately this affects the ability of client library functions such as
those in .NET to return the number of rows affected.)
regards,
Paul Ritchie,
Christchurch
New Zealand.
- Next message: Steve Kass: "Re: Query Excel"
- Previous message: Steve Kass: "Re: Comprable technique to Yukon's "WITH", in 2000?"
- Next in thread: Paul Ritchie: "Re: Default setting for NOCOUNT?"
- Reply: Paul Ritchie: "Re: Default setting for NOCOUNT?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
