I got around this error by setting the NOCOUNT ON at the geginning of the procedure and then setting NOCOUNT OFF at the end

BEGIN

SET NOCOUNT ON

...

SET NOCOUNT OFF

END