MSSQL Express

Question

What is the limit with regards to users and database size of the MSSQL Express version?

Answer 1

For SQL Server 2008 R2 Express Edition:

Database limit is 10GB.

User connections limit is 32767.

Answer 2

Hi,

Please check this LINK it contains the same question and the answer and many links for more detials.

I hope this is helpful.

Elmozamil Elamir

MyBlog

---

Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid
http://elmozamil.blogspot.com

Answer 3

Please refer

http://www.microsoft.com/sqlserver/en/us/editions/express.aspx

Top Express Features

• Supports 10 GB of storage per database.
• Backup and restore with ease.
• Compatible with all editions of SQL Server and SQL Azure.
• Designed to work with Visual Studio and ASP.NET.
• Available with a graphical management tool.
• Offers reporting capabilities, full-text search, and spatial support.

---

Thanks
Manish

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 4

So the Free version allows 32767 users?

---

Bruce Golding

Answer 5

So the Free version allows 32767 users? -  Theoretically yes, but good luck trying to get there without Express resources running out.

Here is an example of Express getting around 8000 sessions