http://www.sqlservercentral.com/blogs/andy_warren/2008/05/20/pop-quiz-what-s-the-max-number-of-resultsets-supported-by-management-studio/

Printed 2014/12/18 12:30AM

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

By Andy Warren, 2008/05/20

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.

 


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.