Quick question: is the 4GB limitation on EACH database or for the installed instance of SQL Server? As you know you can create more than one DB in an instance of SQL Server...
+5
A:
Yes. It's per database, not total. If you want to be really clever you have store a lot more than 4GB by spreading it over multiple databases (or even multiple instances).
Joel Coehoorn
2009-06-05 13:46:17
+3
A:
According to SQL Server 2005 Express Edition Features:
Scalability and Performance
- Supports one CPU, but can be installed on any server
- 1 gigabyte (GB) addressable RAM
- 4 GB maximum database size
Andrew Hare
2009-06-05 13:48:09