Member Avatar for cVz
cVz 19 Junior Poster

I get the following message when executing a stored procedure.

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.

However , i cannot change the fact that the SP uses a cursor.

Basically what happens is that the SP executes into a declared table, and then for each row it executes a new stored procedure bringing the number of result sets to about 20 000....

Any advice on where i can change this setting ?

Regards,

  • 1 Contributor
  • 0 Replies
  • 98 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.