• Try this one: exec sp_configure 'show advanced options', 1

    go

    reconfigure

    exec sp_configure 'min server memory (MB)'

    GO

    exec sp_configure 'max server memory (MB)'

    GO



    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]