Refer this article.

http://technet.microsoft.com/en-us/library/ms146874(v=sql.105).aspx

Ken... You are a genius!!! Thank You very much!!!

Do you have RPC enabled for that linked server, server options?

Check the view that you are trying to open. It might be selecting from a table from different database.

I agree with Monster but to answer your question, don't you have max server memory settings? Set that one.

Also go over this blog, it shows some tricks.

http://serverfault.com/questions/108192/how-do-i-get-sql-server-to-release-its-memory

No.

Can you check if the user has added to the role

db_denydatawriter

There is a fix on these posts.

http://www.sqlservercentral.com/Forums/Topic768507-359-1.aspx

http://www.sqlservercentral.com/Forums/Topic581296-359-2.aspx

DENY ALTER ON SCHEMA::[dbo] to [someuser]

Can you check the DB if those users are disabled?

We flush if there is bad plan. You can flush specific plan which is causing the issue.

If query is running it's plan can't be flushed.

What's the verion of .net on this box?

Is this 32bit or 64 bit OS? How about SQL is it 32 bit or 64 bit?

What's the version of SQL server?

Does it happen right after you restart your sql service?

download sqlcon32.exe , it's good tool to test ODBC connectivity. Post the results.

Allocate 6 gb to sql server and increase the size of page file.

is it active/passive?