Do you have over 2GB of RAM? If you look at the bottom of the window
when changing the value, you'll notive it is in megabytes. :) TempDB
is ram *NOT* included in the SQL memory allocation, either. So when you
add the two together, you must have atleast more ram than those (plus
an OS overhead).
-- Dale E. Reed Jr. (firstname.lastname@example.org)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com