Importing a sql script using sqlcmd throws "insufficient system memory error"

Question

I am trying to import a 50mb sql file using sqlcmd but it throws the following error:

There is insufficient system memory in resource pool 'default' to run this query error.

sqlcmd import error

I am running SQL server 2019 Developer in an EC2 instance having 4GB memory. SQL server is set to use default memory (2147483647 MB). I also tried with sql service in single user mode by running "NET START MSSQLSERVER /f /mSQLCMD" but still no luck. Can anyone suggest what could be wrong?

Aaron Paul · Accepted Answer · 2022-09-27 08:51:01Z

0

The problem is fixed by adding a GO statement after every thousand rows as suggested by @Remus Rusanu here: https://stackoverflow.com/a/1995728.

answered Sep 27, 2022 at 8:51

Aaron Paul

1

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Importing a sql script using sqlcmd throws "insufficient system memory error"

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related