Monday, November 22, 2021

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

 This error might be happen when you are inserting so many data. Follow these steps

Open cmd.exe as Administrator.

Create Documents directory.

Put your SQL Script file(LCScripty.sql) in the documents folder.

first change the path in cmd prompt by using cd then enter this command and replace with your credential database name and filename

sqlcmd -S <YOUR-SERVER> -U <YOUR-USER> -P <YOUR-PASSWORD> -d <YOUR-DATABASE> -i LCScripty.sql