[AccessD] SQL Server Express - true skinny

<<So the question is, would SQL Server express be capable of replacing Jet
for a complex bound 
application for 30 users?>>

  I've never had occasion to try it myself, but from what I understand, for
2005 and up that is correct.  The old 5 connection limit was removed.

  However the DB limit is 4GB, not 10.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Friday, September 10, 2010 2:09 PM
To: Access Developers discussion and problem solving; Sqlserver-Dba; VBA
Subject: [AccessD] SQL Server Express - true skinny

Does anyone know the true skinny on the limitations placed on SQL Server
express in order to 
"throttle" it.?

I found a blog that claims that outside of CPU / Memory / DB size
limitations, there is not other 
"governor".

So it appears that the limitations are:

10 gig db file size.  This does not discuss additional database files.
1 CPU.  However it appears that it can use 4 cores if available
1 gig of memory.  This appears to be the killer.

But there appears to be no "user" limitations etc.

So the question is, would SQL Server express be capable of replacing Jet for
a complex bound 
application for 30 users?


-- 
John W. Colby
www.ColbyConsulting.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com