SQL server error - There is insufficient system memory in resource pool 'internal' to run this query

Hi, am having problems running a SQL query in a .NET application. Getting the above error -
'There is insufficient system memory in resource pool 'internal' to run this query'

My machine has SQL Server Express 2008 R2 with 4GB RAM. Also installed latest service packs (SP2) - http://support.microsoft.com/kb/982854. Then changed the min and max memory for SQL Server. Also increased the virtual memory and ran Windows Update.

The same application and query works on other machines except this. Any idea why??
tjoseph833Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Anthony PerkinsCommented:
Not sure if you are aware but SQL Server Express will only support 1GB.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Anthony PerkinsCommented:
But I would start, by posting the query that is causing you problems and some details about the tables involved (any indexes, row count) and expected output.
Stef MerlijnDeveloperCommented:
You might also want to analyse your query with Activty Monitor in SSMS.
http://msdn.microsoft.com/en-us/library/ms175518.aspx
Have a look in "Recent Expensive Queries"
Get Blueprints for Increased Customer Retention

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

Anthony PerkinsCommented:
Not sure if you noticed but the question has been abandoned for nearly 6 months and the author is MIA.
Stef MerlijnDeveloperCommented:
Doesn't matter. Anyone who searches for this might find it useful :-)
tjoseph833Author Commented:
sorry for the late response. the problem wasn't solved.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.