Home Forums SQL Server 2005 Development Error-Not enough storage is available to complete this operation. RE: Error-Not enough storage is available to complete this operation.

  • hi all,

    Thanks for your feedback.

    OS is not the issue here nor the space still I have more than enough remaining on my disk.

    I am using multiple INSERT Statement to build large SQL statement...

    For eg

    I read from file differnet column values and build Simple INSERT statement...

    file may contain more than 20,00 Rows /lines

    for i=0 to No.Of Rows

    INSERT INTO (...)

    next

    If my file large enough it bombs me out!!!!

    What should be optimized solution, that it would not effect if run on different system with minimum configuration?

    Should I process SQL in small batches ??? Then what should be size limitation on that?

    Really appreciate your answer.