SQL Server 2005, Not enough storage when inserting records.
Posted on 2008-09-29
We have written an application which migrates from an interbase database to SQL Server 2005.
The software works fine on a development station when both interbase and sql server 2005 are on the same machine. ( we have tested millions of inserts on many different dev stations).
In Production, the migration software (running on same machine as interbase), cannot appear to insert specific records into the database, reporting error "Not enough storage is available to complete this operation"
The destination database should have ample space, and memory, and inserts are failing every time (not intermittent).
My suspicion is that it had something to do with running the software via the network or possibly something to do with a blob field (which causes space lookup which gets executed incorrectly possibly because of the via network scenario).
Note that other records insert fine.
Any thoughts as to what could be causing this ?