maximum users logged in sql express

we're planning to use sql express as our database server in our office. the database will consist of accounting, purchasing, marketing, sales, inventory, production and hrd tables. 80-100 users will use the system simultaneously in adding, editing, deleting, reports.
i need some advice on the following:
1. maximum users that can log on to the database simultaneously?
2. maximum size of the database?

tnxHi,

the maximum number of users will be most likely limited by hardware ressources not by a logical threshold, its around 32k users. maximum size of each database is 4GB.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

This is not what Express Edition was built for. The Express Edition exists to provide a small footprint database platform for use with primarily local or embedded applications. It is not designed to stick it on a server, write enterprise level applications against it, and then have 80 - 100 people bang away on it.

You want to deploy either the Workgroup Edition or the Standard Edition.

|||hi, i tried to install sql express w/ advanced services on a server and it works fine. also found info on its features http://www.microsoft.com/sql/editions/express/features.mspx

i already suggested on these sql editions but the company cannot afford the software.
|||hi, do you mean if RAM is increased on the server, more users can log on and perform transactions simultaneously.

how can i monitor if 32k users is already logged on to sql server?|||

Very hardware limitation and ressources will limit the performance as well as availbility.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Truthfully, if you have 80 - 100 users hitting a database server that your company is obviously running its business off of and they can't afford to purchase about $10K worth of software to make sure they can function, they is something fundamentally wrong with the company. They are going to have several times that amount of money spent on the computers these people are working on. So, it really boils down to a very simple question - does the business want to run or not?