"There is insufficient system memory to run this query"

If you get "There is insufficient system memory to run this query" in SQL server 2005 SP2

http://support.microsoft.com/kb/951217/en-us

Try the fix that you can get from above link.