Out of memory when scripting stored procedures | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Out of memory when scripting stored procedures

Hi,
When I try to script my 5000 SPs in sql2005 on my 2GB RAM PC, I ALWAYS get an out of memory error and the scrpting never finishes. When I select a few SPs it works.
Know problem ?
if it is 5000 Sps then that may be a fair error/
does this works for SQL 2000 —————————————-
Yes, it works very well in sql2000.
I get that error when I am working on the client PC. On the server the procedure goes to the end.
Run PERFMON during this operation to see where it is lacking. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
My memory counters seem to be ok.
here’s the error message :
"Exception of type ‘System.OutOfMemoryException’ was Thrown" Avec mes meilleures salutations
With my best regards
Pascal Miserez
BMC, Suisse
Informatique de gestion Ph : +41 21 654 5050
Fax : +41 21 654 5030
Web : www.bmc.ch
E-mail : [email protected]
SMS : [email protected]

What is the operating system and its service pack?
Also the level of Service pack on SQL server?
http://support.microsoft.com/kb/274750/ fyi about using efficient memory. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
The client PC is running XP SP2 with SQL2005 (standard edition) SP1.
The exact SQL version is : 9.00.2047.00 Avec mes meilleures salutations
With my best regards
Pascal Miserez
BMC, Suisse
Informatique de gestion
Web : www.bmc.ch
E-mail : [email protected]
SMS : [email protected]

]]>