Running large MSSQL scripts & resulting memory errors

home
database
view story

7 Kicks

Running large MSSQL scripts & resulting memory errors(diaryofaninja.com)

submitted by wiredone(917) 2 years, 8 months ago

Today i was battling in the trenches while trying to fix a deployment issue on a foreign webhost with a support team that had a lead time of 3 days on a support ticket when i came across a very annoying issue. While trying to import a large MSSQL script (140mb) i was having a repeated dual to the death with the error “701 Insufficient Memory” and his evil twin (kind of like the white dreadlock guys in the Matrix) - “System.OutOfMemoryException” in SQL management studio. But never fear, there is a solution, and its really simple.

add a comment |category: Database |Views: 159
Tweet