Krishna1 (7/17/2013)
folloing link shows maximum memory as 1GB http://msdn.microsoft.com/en-us/library/ms143685(v=sql.105).aspx
Aah, you didn't mention you are using the SQL Express version.
Yes, this version of SQL is limited to 1GB. You can probably set the MAX MEMORY to a higher setting, but it won't allocated more then 1GB.