Max connections in sql server 2000 MSDE

Hi !

What is the max number of connections in sql server 2000 MSDE ?

I have found three opinions on the web: 5,8 and unlimited(32,768...)

Which is true ?

/hakan

I don't think there is any limit to the number of connections. . .

there is a throttle on performance based on number of concurrent connections. the actual number that triggers the throttle i beleive depends on build/sp.

that being said. . . if you build your app correctly and design you database properly, you could probably service 100 to 200 concurrent users of your windows app without seeing a performance hit and thousands of concurrent users of a web app. thats just an opinion, don't ask me to prove it. but I will keep repeating that until someone from MS tells me differently.

but, build you app/db improperly and it doesnt matter which version of sql server you use. performance is going to suck any way.

matrix

Hello,
I have a matrix on a report with an underlying data set of 15 fields.
When the report viewer exports to HTML with Office Web components,
they can only access fields that have been added to the matrix layout.
Is there a way to make all fields of the underlying dataset available
to the viewer without adding them all to the matrix layout?
Thank you in advance for any help.
CraigNot that I am aware of.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Craig" <canei32@.hotmail.com> wrote in message
news:9ef7792a.0408260617.7f345e3d@.posting.google.com...
> Hello,
> I have a matrix on a report with an underlying data set of 15 fields.
> When the report viewer exports to HTML with Office Web components,
> they can only access fields that have been added to the matrix layout.
> Is there a way to make all fields of the underlying dataset available
> to the viewer without adding them all to the matrix layout?
> Thank you in advance for any help.
> Craig

Master-detail on the same dataset

Hello,
I have a dataset (web service) which profide the following data:

ProdID ProductName ItemID ItemName
12 ABC AF Item1
12 ABC AE Item2
13 DEF AF Item1
13 DEF AN Item3

I would see the table rendered as

12 ABC
AF Item1
AE Item2
13 DEF
AF Item1
AN Item3

I tryied setting groups but I don't see the correct data (just the first record)

Any help ?

Thanks,
Pierre

Salut Pierre,

Try to add ProdID and ProducName, in the "Group on" options of your list

Regards

Ayzan

|||

Hello Ayzan,
not really clear what you mean.

I have a table with one header and two rows. In the first row I have ProductID and ProductName. In the second row I have ItemID and ItemName.

Where should I set the group info ?

Thanks,
Pierre

|||

OK, I found it. I set the group info on the wrong row. Thanks for the help.

Pierre