asked on

SQL Server: Generate Scripts fails with Out of Memory exception

I suddenly cannot generate scripts for my stored procedures. It fails with an Out of Memory exception! I have verified it is not out of memory and this will happen even if I script only one procedure (Database -> Tasks - > Generate Scripts).

I can however script procs individually by going to the proc in management studio and "Script Stored Procedure as... Create.

I am using Microsoft SQL Server 2008 10.0.1600.22 and I have applied all patches.

Does anyone esle know what is going on?

RiteshShah

are you selecting only SPs in the wizard? where do you generate script?? I mean in new query window or in memory etc.

MarcGraff

ASKER

To a new query window. SPs fail this way and so do scripting views. This occurs even when scripting a single SP.

MarcGraff

ASKER

My computer nor the server ever is low on memory.

SOLUTION

Raja Jegan R

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

MarcGraff

ASKER

Thanks rrjegan17 but unfortunetly this does not realy help me. Is there some whay around this?

Thanks!

Raja Jegan R

MarcGraff,
I meant to say that its a known issue with SQL Server 2008 Generate Scripts Wizard and hence it might probably get fixed in the next Service pack or you may request the hotfix from the link provided above.

Have you tried installing hotfix from that link

MarcGraff

ASKER

I must be missing the hot fix. Where do you see this?

I have installed CU3 but this did not fix the issue.

SOLUTION

Raja Jegan R

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

MarcGraff

membership