<div>
How are you running the script...?<br />
Recently i run a script for insert a 1GB worth of data...
</div>


How are you running the script...?
Recently i run a script for insert a 1GB worth of data...

<div>
I simply took the entire script and copied it into SSMS. This is SQL 2014. This computer only has 8GB RAM so perhaps that is what is causing the limitation.
</div>


I simply took the entire script and copied it into SSMS. This is SQL 2014. This computer only has 8GB RAM so perhaps that is what is causing the limitation.

<div>
<div class="content wysiwyg-content">
Is there a size limitation on a script for MS SQL? I was sent a script to insert data into a table. When I try to run it all I get is Query Execution failed. There is no further explanation. The script has insert commands for over 10,000 records. If I chop the script up into 1,000 record chunks they all go in so I am thinking the initial script is just too big.
</div>
</div>


Is there a size limitation on a script for MS SQL? I was sent a script to insert data into a table. When I try to run it all I get is Query Execution failed. There is no further explanation. The script has insert commands for over 10,000 records. If I chop the script up into 1,000 record chunks they all go in so I am thinking the initial script is just too big.

Size limitation of MS SQL script

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.