GROUPING SETS in What's New (Database Engine)

Just as a usability issue, most of the topics mentioned in the "What's New" documents have a link to further information. The GROUPING SETS item under "What's New in CTP 1" at /s10de_0evalplan/html/8f625d5a-763c-4440-97b8-4b823a6e2439.htm should contain a link to the GROUPING SETS topic. Of course, the GROUPING SETS entry in the index currently points to /s10de_6tsql/html/c1050658-b19f-42ee-9a05-ecd6a73b896c.htm which is actually the topic GROUPING_ID (Transact-SQL).

I realize that "What's New in CTP 1" will go away but I assume these groups of topics will be combined into a grander "What's New in SQL Server 2008" section distributed with RTM Books Online.

Hi Aaron,

Thanks for the good suggestions.

Regards,

Gail

GROUPING SETS in What's New (Database Engine)

Just as a usability issue, most of the topics mentioned in the "What's New" documents have a link to further information. The GROUPING SETS item under "What's New in CTP 1" at /s10de_0evalplan/html/8f625d5a-763c-4440-97b8-4b823a6e2439.htm should contain a link to the GROUPING SETS topic. Of course, the GROUPING SETS entry in the index currently points to /s10de_6tsql/html/c1050658-b19f-42ee-9a05-ecd6a73b896c.htm which is actually the topic GROUPING_ID (Transact-SQL).

I realize that "What's New in CTP 1" will go away but I assume these groups of topics will be combined into a grander "What's New in SQL Server 2008" section distributed with RTM Books Online.

Hi Aaron,

Thanks for the good suggestions.

Regards,

Gail

Grid results in Management Studio

Hi
When I run a query in Management Studio, I get this message -
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 change this limit so I can get all results?
Regards
SteenWhich version are you using ? On SQL 2005 Ent. RTM version I don't have
this problem. I can select 1000000 rows and all are displayed in the
grid.
Markus|||Rows is not the same as resultsets. Steen has the problem that the query returns > 100 result sets.
AFAIK, this is not a configurable limit.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1132222959.738766.69660@.g47g2000cwa.googlegroups.com...
> Which version are you using ? On SQL 2005 Ent. RTM version I don't have
> this problem. I can select 1000000 rows and all are displayed in the
> grid.
> Markus
>|||Tibor Karaszi wrote:
> Rows is not the same as resultsets. Steen has the problem that the query returns > 100 result sets.
> AFAIK, this is not a configurable limit.
>
Thanks Tibor. It's not a major problem - it's just annoying when it
happens..;-). I've also looked around to see if I could find somewhere
where it could be configured but with no luck.
Regards
Steen

Grid results in Management Studio

Hi
When I run a query in Management Studio, I get this message -
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 change this limit so I can get all results?
Regards
Steen
Which version are you using ? On SQL 2005 Ent. RTM version I don't have
this problem. I can select 1000000 rows and all are displayed in the
grid.
Markus
|||Rows is not the same as resultsets. Steen has the problem that the query returns > 100 result sets.
AFAIK, this is not a configurable limit.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1132222959.738766.69660@.g47g2000cwa.googlegro ups.com...
> Which version are you using ? On SQL 2005 Ent. RTM version I don't have
> this problem. I can select 1000000 rows and all are displayed in the
> grid.
> Markus
>
|||Tibor Karaszi wrote:
> Rows is not the same as resultsets. Steen has the problem that the query returns > 100 result sets.
> AFAIK, this is not a configurable limit.
>
Thanks Tibor. It's not a major problem - it's just annoying when it
happens..;-). I've also looked around to see if I could find somewhere
where it could be configured but with no luck.
Regards
Steen

Grid results in Management Studio

Hi
When I run a query in Management Studio, I get this message -
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 change this limit so I can get all results?
Regards
SteenWhich version are you using ? On SQL 2005 Ent. RTM version I don't have
this problem. I can select 1000000 rows and all are displayed in the
grid.
Markus|||Rows is not the same as resultsets. Steen has the problem that the query ret
urns > 100 result sets.
AFAIK, this is not a configurable limit.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1132222959.738766.69660@.g47g2000cwa.googlegroups.com...
> Which version are you using ? On SQL 2005 Ent. RTM version I don't have
> this problem. I can select 1000000 rows and all are displayed in the
> grid.
> Markus
>|||Tibor Karaszi wrote:
> Rows is not the same as resultsets. Steen has the problem that the query r
eturns > 100 result sets.
> AFAIK, this is not a configurable limit.
>
Thanks Tibor. It's not a major problem - it's just annoying when it
happens..;-). I've also looked around to see if I could find somewhere
where it could be configured but with no luck.
Regards
Steen