Ran across this strange occurence while doing some testing. To duplicate the results (the actual code was a little more complicated) run this:
select top 1 * from sysdatabases
go 101
And you get:
Batch execution completed 101 times. The query has exceeded the maximum number of result sets that can be displayed in the results grid. Only the first 100 result sets are displayed in the grid.
I'd like to think returning more than a 100 resultsets is rare. Mildly curious about why the limit is 100 or if it can be changed, but not that curious.