Information about MSDE

I've a question...
How many user can I supporto in a webapplication with MSDE?
Thanks
Hi,
There is a great thread called "MSDE limits" below that has the following
info.
Cheers
Scott
"MSDE 2000 LIMITS
- MAX SIZE IS 2GB
- 2 CPUS
- NUMBER OF USERS. The limit is not based upon concurrent connections. It is
based upon concurrent "workloads". There is a big difference between this
and concurrent connections. When the system needs to execute more than 8
concurrent query plans, it inserts a delay in each logical page access. For
small queries, this can have a minor effect. For larger table scans, this
can have a large effect. Use DBCC CONCURRENCYVIOLATION to investigate if any
delays have been inserted and how often. 20 users can be happy with a single
instance of the MSDE but depends on application workload. The 2G database
size limit seems to impact most people before the query governor does.
NOTE: actually allows 32,767 connections to an instance of the database.
Further reading on "The SQL Server 2000 Workload Governor" can be sound
here.
http://msdn.microsoft.com/library/?u...asp?frame=true"
|||Thanks for informations

Info regarding MSDE

Hi

Iam not sure if the Question is approriate for this forum but here goes...

I have just started playing around with ASP .NET and since i do not have a lot of money i downloaded and installed MSDE as my database. So far i havent been able to find any free tools to access MSDE. Iam looking for GUI tools from where i can create Databases , tables etc... I have experience with MySQL database and am looking for something like MySQLAdmin for MSDE..

any help in this regard is appreciated

Thanks
PunitThe ASP.NET Web Matrix andthis blog might help.

Regards,sql