Paul White (3/13/2010)
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
I just forced the same sort of error. I processed a couple of GIGs and disabled the autogrowth on the log file. I also kept the log file small.
Thus I would say yes it is a big file being processed and there are other factors at play such as autogrow, disk space, small log or data file, or something of that nature.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events