Cannot execute script: Insufficient memory to continue the execution of the program

Question

I have a 123MB sql file which I need to execute in my local PC. But I am getting

Cannot execute script: Insufficient memory to continue the execution of the program

How to solve this issue?

Answer 1

use the command-line tool SQLCMD which is much leaner on memory. It is as simple as:

SQLCMD -d <database-name> -i filename.sql

You need valid credentials to access your SQL Server instance or even to access a database

Taken from here.

Answer 2

It might help you! Please see below steps.

sqlcmd -S server-name -d database-name -i script.sql

• Open cmd.exe as Administrator.
• Create Documents directory.
• Put your SQL Script file(script.sql) in the documents folder.
• Type query with sqlcmd, server-name, database-name and script-file-name as like above highlighted query or below command line screen.