Errors when uploading DDL and Data file created by Database Publishing Wizard

Hi,

I needed to recreate/publish a DDL and data file(of a database) that was produced using Database Publishing Wizard. The size of the file is 4G. I receive the following error when I try to open it up in the new query window of sql server 2005 (sp2)for execution.

"The operation could not be completed. Not enough storage is available to complete this operation."

I know my server has 829G of free storage space available. i receive no errors when I open up a smaller file also created by database publishing wizard.

What possibly is causing this?

Thanks in advance

Hi Hamdaweh,

When you attempt to open this in QA, it is attempting to load the entire 4GB+ into system RAM, that's why you are receiving this error. Try opening it with a specialist text editior and chunking it down into smaller files, and then run each via QA.

Cheers,

Rob

|||Thanks. So can i say the database publishing wizard is good for only DDLs and small data?