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??