This is a great set of explanations of the various configuration settings for SQL Server 2000, what the defaults are, when you might need to change these values, etc.: