Tempdb is in MB NOT 2k blocks. Memory is in 2k blocks.
> > I want to move my tempdb from disk to ram. I've tried this once and MSSQL
> >wouldn't start after I stopped it. I want to know exactly what values to
> >change. I've got 128mb of ram and could use up to 32mb of it for the tempdb.
Make sure that the total of memory allocated (in 2k block) plus the
memory allocated to tempdb (it is *NOT* included in the memory of
SQL Server itself is less than 80% of your physical RAM.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com