To elaborate on Sergey's response, if you don't want a result set, issue:

Set NoCount On

In your stored procedure. It is off by default. When you encounter a statement that should return a result set, be sure to issue

Set NoCount Off