SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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.



I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.


No comments.

Leave a Comment

Please register or log in to leave a comment.