Home Forums SQL Server 2005 T-SQL (SS2K5) 701: There is insufficient system memory to run this query RE: 701: There is insufficient system memory to run this query

  • Hi

    I presume it is so big because this is your initial setup of all the tables?

    Or do you expect it be this big every time you move from staging to production?

    Is it not possible to get the script text and break it down into smaller pieces and run them separately this time only then for subsequent updates the script should be smaller.

    Otherwise have a look at SQL Packager from Red-Gate. It works pretty well. It also does more than just tables. (I'm not a rep for Red-Gate, I just appreciate their products.....)