When I try the following:

exec sp_configure 'min server memory (MB)'

I get the following error:

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51
The configuration option 'min server memory (MB)' does not exist, or it may
be an advanced option.

Thoughts or suggestions?

Hi Shane

As the error message implies, this option is an advanced option, so you
first have to make sure that Show Advanced Options is enabled

EXEC sp_configure 'show advanced options', 1
RECONFIGURE

Another possibility is that you are just mistyping. If you type in the whole
option name, you must be exact. SQL Server does allow you to use any
unambiguous substring, so you might try a shortened form:

exec sp_configure 'min server memory'

Show quoteHide quote

On Mon, 24 Apr 2006 10:47:02 -0700, Shane C
<Sha***@discussions.microsoft.com> wrote:

Shane,

As a first step use the following to show advanced options:

USE master;
GO
EXEC sp_configure 'show advanced option', '1';
RECONFIGURE

Then use
EXEC sp_configure;
to display those options

If you wanted, for example, to set min server memory to 300 use
EXEC sp_configure 'min server memory (MB)', '300';
RECONFIGURE WITH OVERRIDE;

Andrew Watt [MVP]

SQL 2005 Flat File source (in Import wizard) missing
What's the best way to keep a live db and an archive db?
run Profiler on a specific SP/Query/Function
Need Help with "System.Data.SqlClient.Sqlerror: Cannot open backup device (DLT tape) ...
SQL Server Profiler