Re: SET NOCOUNT ON OPTION

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 10/19/04 

Date: Tue, 19 Oct 2004 09:06:20 -0400

> Therefore, you need to have the NOCOUNT set to OFF

Can you show an example where the NOCOUNT setting affects @@ROWCOUNT? Like
Adam, I use SET NOCOUNT ON in every single procedure I write, and I have
never found a case where I had to set it OFF at any point in the procedure.