<p>Within a stored procedure, another stored procedure is being called within a cursor. For every call, the SQL Management Studio results window is showing a result. The cursor loops over 100 times and at that point the results window gives up with an error. Is there a way I can stop the stored procedure within the cursor from outputting any results?</p>

<pre><code>  WHILE @@FETCH_STATUS = 0
  BEGIN
    EXEC @RC = dbo.NoisyProc
    SELECT @RValue2 = 1 WHERE @@ROWCOUNT = 0
    FETCH NEXT FROM RCursor INTO @RValue1, @RValue2
  END
</code></pre>

<p>Thanks!</p>

Place:
```
```
SET ROWCOUNT OFF
/* the internal SP */
SET ROWCOUNT ON
```
```
wrap that around the internal SP, or you could even do it around the SELECT statement from the originating query, that will prevent results from appearing.