Mem leaks with SQL 2000

[Norbert]

When start SQL Server the MEM usage continue to increase
even when activity is low. How do I solve this problem?
The physical memory is 2 GB and after a few hours the
usage goes to 1.8 GB causing not able the connect with
ODBC error in the front end MSACCESS db.

 

[Arvin Meyer]

You can limit the memory, number of processors, and processing power that
SQL-Server uses by going into the Services management console and setting
those attributes. Generally, the maximum that you should ever let the
processor use is 85%.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access