Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SET NOCOUNT OFF Expand / Collapse
Author
Message
Posted Monday, August 10, 2009 3:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 8, 2013 1:54 AM
Points: 7, Visits: 34
sorry, it is better to put SET NOCOUNT ON, isn't it?
Post #767696
Posted Tuesday, August 11, 2009 7:53 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, July 3, 2011 7:09 AM
Points: 233, Visits: 494
Correct. If you don't need to get any responses from things like update statements, then best to turn this off - this reduces traffic to and from the server. Helps (even if only slightly) with performance.

Random Technical Stuff
Post #768603
Posted Wednesday, August 12, 2009 2:07 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, November 20, 2014 11:54 AM
Points: 819, Visits: 2,116
I would recommend not setting that in the stored procedure because this reduces the possibilities of the return. When the stored proc is called from programming code, the call can be set to not return a record count. If it's set in the stored proc, the programmer has no way to get the count if it would be desired.


Post #769163
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse