Execute Script Error Resolved In SQL Server Management Studio
Execute Script Error – Imagine my surprise when I tried executing a rather large SQL script (255 Mb) and received an error telling me that there was ‘Insufficient memory to continue the execution of the program. (mscorlib)’. You might be wondering why I would even have such a large script to begin with.
Looking for something else? Try these links instead:
- Prevent Accidental Table Data Deletion In SQL Server Management Studio
- Automate Standard Comment Blocks For New SQL Queries
- Azure Databases – Restore Local Database To Azure
- Easily Generate Table Change Scripts In SQL Server Management Studio
- ApexSQL Provides Excellent SQL Tools For Free
Well I had to import data from a file that I didn’t have access to any more, so I decided to script the table contents from the live database and import into my dev database for testing. Trying to run the query produced the error and I had to find an alternative way to get the data into my table. (more…)