Exception of type 'System.OutOfMemoryException' was thrown

Topics: Database Publishing Wizard
Dec 22, 2006 at 5:38 PM
Every time I try and run the Database Publishing Wizard, during the "Writing script to disk" process I receive the message "Exception of type 'System.OutOfMemoryException' was thrown". The script file is only partially complete. Anyone have any ideas?
Dec 22, 2006 at 7:02 PM
Hi jamfahr -

A few quick questions:

- How big is the database you are trying to script (number of tables, views, stored procs, etc). How many rows?
- How much memory do you have installed in your machine?
- How much memory is free when you try to script the databas?

Thanks,
alex