Not enough storage available to complete this operations

• sbauer

  SSCommitted

  Points: 1966

  More actions

  June 6, 2006 at 4:49 pm

  #74986

  I'm trying to import a 4.4gig text file into a table in a SQL 2000 database.

  I'm getting the error above when it tries to import.

  I've seen error messages where you don't have enough room in either the data file or log file, but not such a general statement.

  Anyone have any ideas what could be causing it?

   

  Thanks in advance

  Susan

   

• sbauer

  SSCommitted

  Points: 1966

  More actions

  June 6, 2006 at 5:05 pm

  #642164

  Figured it out!!

  When the file was importing the table it created had a varchar8000 for each column (a very wide table).

  WHen I modifed the column data types the data went in with no problems.

   

  Thanks

  Susan