How to increase the no.of resultsets in grid form

Question

How to increase the no.of resultsets in grid form

madhu-686862

SSChampion

Points: 10707
More actions
June 2, 2008 at 4:57 pm

#124004

hi,
when I executing a query it giving the following error:
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.
is there any way to increase the resultsets more than 100?
Thank You

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184393 More actions · Answer 1

Don't know how to or if you can do it. The question really is "Why do you need to do it?" There is a probably a set based method to do what you need that will return the data in 1 result set.

Unless you have written over 100 queries to run in one SSMS session?

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

RBarryYoung SSC Guru Points: 143329 More actions · Answer 2

If they have the same columns, try to combine them with Unions.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Ken Simmons SSCertifiable Points: 7822 More actions · Answer 3

If you change the results to text you will not get ther error.

Depending on what you are doing you may be able to store the results in a temp table and then display the output. I have seen this error when you run a sp that uses a cursor like sp_msforeachtable. If this is the case you could do something like...

Create Table ##tmpResults

(col1 int,

col2 int)

Insert into ##tmpResults

exec sp_msforeachtable 'sql statement'

Select * from ##tmpResults

Drop table ##tmpResults

samsql Hall of Fame Points: 3044 More actions · Answer 4

samsql

Hall of Fame

Points: 3044

June 5, 2008 at 1:11 am

#824662

use this command

set rowcount 1000000

Manie Verster SSCertifiable Points: 7152 More actions · Answer 5

maruf24 (6/5/2008)
use this command
set rowcount 1000000

Call me stupid but can someone I am not sure what is meant by resultset. Do you mean rowset or recordset? In that case the above might work.

Confusius said: "Ask a question and be a fool for a second, don't ask and remain a fool forever"

:-PManie Verster
Developer
Johannesburg
South Africa

I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)