Well not any more baby! Every now and again whilst casually browsing the net of a lunchtime I stumble across an absolute gem of an article, and this piece from Jeff Atwood is just such a precious nugget:

http://www.codinghorror.com/blog/archives/000555.html

The guy's a genius, I'm telling you, and I'd thoroughly recommend his blog as being jam-packed with useful tidbits of information. Those of you with longer memories will recollect that I recommended an article on his blog for vanquishing the Windows Update reboot nag dialog.

In this case, if you've got more than 1GB of RAM and you've ever experienced problems with the hibernate feature in WinXP this one's for you. As the title suggests I mean the situation where you get the almost entirely indecipherable "Insufficient system resources exist to complete the API" message. I often get this on my home PC, which I pretty much only use for games and email these days so waiting ten minutes for the thing to start up is a pretty tedious experience. Hibernate cuts that down to under a minute, at least when it works. I probably would experience it with my desktop here at Red Gate but for the fact that I either leave it switched on so I can remote desktop in from home, or shut it down entirely because running the amount of stuff I do a periodic reboot is still a reasonably sensible idea.

Anyway, he points to a hotfix, which you can grab from Owen Cutajar here:

http://www.u-g-h.com/InsufficientSystemResourcesExistToCompleteTheAPISOLIVED.aspx

along with the original Microsoft KB article, which you'll find here:

http://support.microsoft.com/?kbid=909095

Absolutely fantastic, and there's not much more I can say than that really.

(And if you're wondering how exactly I'm finding the time to blog at this point, SQL Prompt 3 Final Beta should be publicly available on our website sometime after 1500 GMT this afternoon. ;) )