NoCount

• Jelena

  Old Hand

  Points: 332

  More actions

  January 27, 2003 at 2:15 am

  #58568

  Hi,

  is it posiible to set nocount to on on a database level?

  Thanks,Jelena

• Antares686

  SSC Guru

  Points: 125444

  More actions

  January 27, 2003 at 4:00 am

  #447252

  No it is not a DB option it is a connection option. You can go into Server properties and on the Connections tab set the default connection properties to "No count" on. But I haven't tested to see if works and is not in BOL documentation but should be it. Note however some apps handle the connection properties on their own. For example in QA if you goto Tool/Options and on the Connection Properties tag look you will see Set NoCount as an option to turn on/off.

• Jelena

  Old Hand

  Points: 332

  More actions

  January 27, 2003 at 4:26 am

  #447255

  When I update options on Sql Server it doesn't affect to default options.After aplication connection I always have:

  set quoted_identifier on

  set implicit_transactions off

  set cursor_close_on_commit off

  set ansi_warnings on

  set ansi_padding on

  set ansi_nulls on

  set concat_null_yields_null on

  set language us_english

  set dateformat mdy

  set datefirst 7