You can change how sql server uses memory in the properties of the sql instance in Enterprise Manager. I had to do this on my laptop.
>When monitoring our server (SQL2000) I notice that after a reboot (once a week), memory usage starts out about 10% (of 2gb) and over a day or so climbs to 80% and stays there until the next reboot. Is this normal? Should SQL release memory when it is no longer needed?
>
>TIA
>John