SQL Server: set nocount on|off

The value of nocount (which can be on or off) specifies if SQL Server sends a message about the numbers of records affected to the client after executing one of the following SQL statements:

• select
• insert
• update
• merge
• delete

It's generally considered good practice to have a set nocount on statement as first statement in a procedure.