Error message in the SQL Server Errorlog file when you concurrently and repeatedly run stored procedures that create and delete many temporary tables or table variables in SQL Server 2005: "There is insufficient system memory to run this query"

By Frank Kalis