Set NoCount Automatically

• Henmi

  Ten Centuries

  Points: 1015

  More actions

  March 11, 2003 at 8:57 pm

  #81142

  Hi,

  I always use SET NOCOUNT ON statement in all my sprocs to improve performance (as stated in the BOL). By Default, the NOCOUNT is set to OFF, I'm just wondering if there is a way to predefine NOCOUNT ON as the default, so that I don't have to worry if someone forgot to put that directive when writing a sproc. Is this possible?

  Thanks for any help

  Hendry

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  March 11, 2003 at 10:33 pm

  #450847

  There is.

  Server Properties > Connections > Check No Count.

  This sets it for all DB's on that server/instance.

  Crispin

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!