sqlt-sqlsql-server-2012
Cannot execute script: Insufficient memory to continue the execution of the program
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?
Solution
use the command-line tool SQLCMD which is much leaner on memory. It is as simple as:
SQLCMD -d <database-name> -i filename.sqlYou need valid credentials to access your SQL Server instance or even to access a database
Taken from here.
- Match java.sql.Timestamp with DB2 Timestamp
- Parse and split comma-separated fields and expression from a SQL SELECT clause
- #1227 - Access denied; you need the SUPER privilege for this operation - how to solve?
- Accessing deeply nested fields using DuckDB SQL
- Using FORALL in Oracle with Update and insert
- JDBI - What's the difference between @define and @bind in JDBI?
- Disable secure priv for data loading on MySQL
- Empty array as PostgreSQL array column default value
- How to list table foreign keys
- Query the lowest sub-value where the main value is grouped
- How important is the order of columns in indexes?
- Select user's high score for each lesson from one table based upon lesson ids in another table
- INSERT rows that were missing for the UPDATE
- Add business days to date in SQL without loops
- Insert into postgres SQL
- Maximum number of products for given amount from the product list in SQL server without using While/Cursor?
- How to convert *sql.Rows to typed JSON in Golang
- SQL: query to select all records from join table
- MergingTwo SQL Queries Select and Count in Single statement
- Converting char to date and pulling past two years data
- How do I query rows of only the max value record of unique IDs within a table?
- How to update a SQL column in a stored procedure if the column was added?
- Blazor .NET 8 - InputSelect: Creating Dropdown from Models
- Execute raw SQL using Doctrine 2
- Keep the longest record in a column for multiple entries
- ClickHouse - creating time table
- SYBASE query with parameter in a stored procedure
- How to execute a stored procedure inside a select query
- MySQL stored procedure throwing [42000][1064] you have an error in your SQL syntax on EXECUTE stat USING statement
- Insert datatable into a mysql table using c#