Disable printing number of affected rows - SET NOCOUNT

• SET NOCOUNT allows disable (or enable) printing number of affetced rows as part of stored procedure result.
• SET NOCOUNT ON - the count is not returned.
• SET NOCOUNT OFF - the count is returned.

   SET NOCOUNT { ON | OFF } 

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