How to set -g startup option? is it permanent?

Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
times a day error: failed to reserve continidous memory of size=6xxxx
We have reseached and found that setting the -g startup option may
solve this problem, but I have no clue how to set it. I have looked
on books online too as suggested with no help.
Is there a permanent way to set this option? We are pretty close to
reformatting and reinstalling at this point.
Thanks in advance.
Kyle
SETUP:
DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
MS Small Business Server 2003
MS SQL Server 2000 w/ Service Pack 3
Icode Everest Enterprise (ERP)
MS Exchange 2003Hi Kyle
This is a startup flag for the sqlservr.exe executable. You can go to
Enterprise Manager and choose the startup parameters button on the General
tab. Add -gNNN as a parameter. Start and restart your SQL Server. You can
read a bit more about this in the Books Online under "Command Prompt
Utilities" (you can also start SQL Server from a command prompt), but you're
not, it's never really clear HOW to set this parameter.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kyle West" <kyle@.wiredspeed.com> wrote in message
news:64202bb4.0407221800.43f847fd@.posting.google.com...
> Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
> times a day error: failed to reserve continidous memory of size=6xxxx
> We have reseached and found that setting the -g startup option may
> solve this problem, but I have no clue how to set it. I have looked
> on books online too as suggested with no help.
> Is there a permanent way to set this option? We are pretty close to
> reformatting and reinstalling at this point.
> Thanks in advance.
> Kyle
> SETUP:
> DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
> MS Small Business Server 2003
> MS SQL Server 2000 w/ Service Pack 3
> Icode Everest Enterprise (ERP)
> MS Exchange 2003