Once every 2 to 3 months the client sends us a giant SQL script to update their web database with changes. The script fails when you try to run it via SQL Server Management Studio due to insufficient memory.
We run the query using SQL Query Analyzer/ Mgmt studio.
Error message: Server: Msg 701, Level
17, State 1, Line 64302
There is insufficient system memory to run this query
Same problem in both SQL 2000 and SQL 2005.
The script contains a series of DELETE and INSERT statements for multiple tables.
The file can be as big as 57973 KB.
There are over 12000 objects in the database not to mention look up tables and join tables. The media table has 65720 records and another table has 97799 records.
We have no way of changing the SQL export we receive from the client.