When writing stored procedures in SQL Server, every execution will be automatically followed by a (mostly useless) execution summary. In most cases, this should be switched off in order to decrease server round trips and network traffic. So it is a good idea to add
SET NOCOUNT ON
at the beginning of any sp.