Error: There is insufficient system memory to run this query

[nduckste]

We're experiencing the following problem on our servers:

Server: Msg 701, Level 17, State 1, Line 3
There is insufficient system memory to run this query.

I've been able to fix the problem by a)Lowering the Max Server Memory and b)Minimum Query Memory.

However, Microsoft state there is a hot fix available for this issue at in KB Article 817262 (
http://support.microsoft.com/default...&Product=sql2k).

Any idea how one is supposed to contact Microsoft to get this fix without paying?

Thanks,

Nick

[MAK]

Why can't you fix the query using temp table?

[rmiao]

Microsoft will not chagre you for hotfix.

[nduckste]

I called them and they did provide the hotfix for free. Thanks.

I also fixed the problem by lowering th Max Memory option without any noticeable performance degradation. If the problem doesn't resurface, I probably won't install the patch. It isn't exactly straightforward to install or uninstall.

P.S. Fixing the query using a temp table was an option but somehow I think even for a complex query, SQL Server should be able to return more than 500 records.