jim.powers (7/3/2008)
This really isn't that hard to understand. The link posted with the question's answer is plainly obvious.http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
In the Workgroup column on the row for RAM, the limit is clearly stated at 3GB.
This has nothing to do with the OS installed on or the amount of installed memory in the system.
Apologies Jim, but the URL I mentioned was the top hit (actually just one of two) when I searched for "Workgroup RAM" in SQL BOL. I should have read the page more carefully before posting.
However, the link given with the answer is also a bit ambiguous, since in the 'Comments' column of the table it says "Memory limited to maximum supported by operating system".
I'll shut up now. 😉