Getting Rid of Rows Affected Message

• Mark Mokris

  SSC Veteran

  Points: 279

  More actions

  May 6, 2006 at 8:57 am

  #172322

  Hi,

  How do I inhibit the nn Rows Affected message at the end of a query in the SQL Query Analyzer?  I don't want the message to appear in my ouput file when I select Results to File.  I am using SQL Server 2000.

  Thanks,

  Mark

• David Burrows

  SSC Guru

  Points: 65142

  More actions

  May 6, 2006 at 9:16 am

  #636410

  Use

  SET NOCOUNT ON

  before your query

  Far away is close at hand in the images of elsewhere.
  Anon.