While reviewing a SQL book, it made note that to help with performance, you could direct the "TEMPDB" to work from RAM. I made a change to the SQL configuration to allow some memory to be used for the TEMPDB in RAM. Changes would not be in affect until SQL restarted.

When I restarted (tried), it wouldn't load. When checking the error log report, it said not enough memory to load IN_RAM. Now, I can't get back to remove the IN_RAM setting. Is there some sort of back-door or config file that I can get my hands on to change this or am I completely hosed... (only beta data but would still be a PITA to reload)..

Any Ideas?