SET NOCOUNT

SET NOCOUNT { ON | OFF } 

• When SET NOCOUNT is ON, the count is not returned. 
• When SET NOCOUNT is OFF, the count is returned.

The @@ROWCOUNT function is updated even when SET NOCOUNT is ON.

http://msdn.microsoft.com/en-us/library/ms189837.aspx