Blog Post

Pop Quiz - What's the Max Number of Resultsets Supported by Management Studio?

,

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.

 

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating