Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What is the command line command to limit SQL 2000 server to 640MB of RAM? This is MSDE2000 and so I don't have access to Enterprise Manager.

share|improve this question
up vote 3 down vote accepted

Have a go at this:

EXEC master.dbo.sp_configure 'show advanced options', 1

EXEC master.dbo.sp_configure 'max server memory (MB)', 640

If you have to do this via a command line tool you can put that into a .sql file (LimitMaxMem.sql) and do this:

osql -E -S servername -i LimitMaxMem.sql

BTW- Enterprise Manager should hook up with MSDE just fine. I used to use it all the time.

share|improve this answer
thanks. that was what I was looking for and it worked. ;-) – djangofan Sep 18 '09 at 17:21
out of curiosity, which method did you use/work for you? exec or osql? – shufler Sep 18 '09 at 17:26
@shufler: You're running the exact same code in either case, it's just whether or not you have a GUI interface like Query Analyzer or if you're using a command line tool like osql. With a GUI you can just type that in and execute it. With osql you can feed in the SQL from a file (or a command line parameter, but a file's much easier). – squillman Sep 18 '09 at 17:37
i just realised now that the osql command was just taking the code from the file. thanks :) – shufler Sep 18 '09 at 19:39

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.