Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smalin
Starting Member
1 Post |
 Posted - 2011-01-13 : 07:12:22
|
| I have installed engine SQL Server 2008 R2 (included SP2) and SQL Server Management Studio 2008 (versio 10.50.1600.1). It all works on my developer machine (Core2Duo E6750, 4GB RAM, Windows Vista 32bit).I use tool Task -> Generate Scripts... but it can't generate aby scripts because system throws OutOfMemoryException while getting list of objects:System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown. at Microsoft.SqlServer.Management.SqlScriptPublish.GeneratePublishPage.worker_DoWork(Object sender, DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)It happens for each database which have over ~5 tables. I'm frustrated.. |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-01-13 : 12:15:47
|
| Seems you are short of memory.Just reboot your system & try.PBUH |
 |
|
|
|
|
|
OutOfMemoryException while generating scripts...