by Joe Havelick
6. March 2008 09:17
The following is my cheatsheet for determining which version(s) of SQL are appropriate for a particular implementation.
| Microsoft SQL 2005 Version Guide |
| Specifications |
Express 2005 |
Workgroup 2005 |
Standard 2005 |
Enterprise 2005 |
| Max CPUs |
1 |
2 |
4 |
None |
| Max Ram |
1GB |
3GB |
OS Limit |
OS Limit |
| Max Database Size |
4GB |
None |
None |
None |
| Management Studio |
Yes |
Yes |
Yes |
Yes |
| 64-Bit Proc. Support* |
No |
No |
Yes |
Yes |
| Advanced Integration Svcs. |
No |
No |
Yes |
Yes |
| Notification Services |
Yes |
Yes |
Yes |
Yes |
| SQL Agent |
No |
Yes |
Yes |
Yes |
| Report Server |
Yes |
Yes |
Yes |
Yes |
| Analysis Services |
No |
No |
Yes |
Yes |
27195ecb-ed22-4182-8a26-bcd1e568c1fb|1|5.0
Tags: sql