<div>
Is that the exact error that you are getting?
</div>


Is that the exact error that you are getting?

<div>
Can you please post the exact error message that you get.
</div>


Can you please post the exact error message that you get.

<div>
&quot;Not enough storage is available to complete this operation.&quot;
</div>


"Not enough storage is available to complete this operation."

<div>
<div class="content wysiwyg-content">
I want to import a large ascii (fixed field) text file: 14MB. &nbsp;I get 'not enough space' error using the import wizard. &nbsp;The drive my SQL Server is on has 9GB. &nbsp;I increased size of mdf &amp;&nbsp;ldf to 100mb and config size to grow by 1MB. &nbsp;Same error. &nbsp;The text file has 228 fixed length fields, the total width of the row is just under 1600 bytes. &nbsp;It has (I'm guesstimating) about 8000+ rows.<br />
<br />
John D'Amato<br />

</div>
</div>


I want to import a large ascii (fixed field) text file: 14MB.  I get 'not enough space' error using the import wizard.  The drive my SQL Server is on has 9GB.  I increased size of mdf & ldf to 100mb and config size to grow by 1MB.  Same error.  The text file has 228 fixed length fields, the total width of the row is just under 1600 bytes.  It has (I'm guesstimating) about 8000+ rows.

John D'Amato


Importing large ascii text file, 14MB.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.