Start SQL Server with -f
More info in Books Online. Search, for instance, for:
Tibor Karaszi, SQL Server MVP
Neil's FAQ at: http://www.sqlserverfaq.com
Please reply to the newsgroup only, not by email.
> I have another question about the same error - what should be done if
> the server did not come up after reboot. I guess I can not bump
> "Tibor Karaszi"
> > Some guesses:
> > Have you used sp_configure to bump up any of below settings?
> > Min server memory
> > set working set size
> > --
> > Tibor Karaszi, SQL Server MVP
> > Please reply to the newsgroup only, not by email.
> > FAQ at: http://www.sqlserverfaq.com
> > in the NT4.0 Event Viewer, the error
> > SQL 7
> > Event ID: 17055 Source: MSSQLServer
> > The description for Event ID ( 17055 ) in Source ( MSSQLServer )
> could not be
> > found. It contains the following insertion string(s): 17122,
> initdata: Warning:
> > Could not set working set size to 649024 KB.
> > "Could not set working set size to ...."
> > i dont understand what it was and how to deal with it
> > finding more information about this SQL error (17122) but havent find
> any clue yet
> > have anyone experienced this kind of Error?
> > ?
> > My system RAM = 640MB
> > June
> Sent via Deja.com http://www.deja.com/
> Before you buy.