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.

  • March 13, 2010 at 4:15 am

    #1133182

    GoGreen (3/12/2010)

    I am trying to import data from file(txt, xls) using multiple Insert statement.

    Is there any limitation on query size that SQL server can handle at one time?

    That looks more like an OS error to me..."not enough storage is available to process this command."

    I am intrigued by your statement above.

    Are you are trying to execute an enormous batch of single-row INSERT statements?

    Please give more details and a small example...there are much, much, better and faster ways of doing this, if so.

    Paul

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi