I was under the impression that the SQL Server will consume as much memory as it wants as demand grows. Before formatting I would try to configure the server to use a fixed amount of memory. Get the properties of the server in the Enterprise Manager, and then in the 'Memory' tab set it to a fixed amount. Personally I would never do this unless you think some other process if using all the memory, and in that case you can just look in the task manager to see each process and how much memory it is taking.

Hope this helps,
Eric Stephani

>While my LAN-users are conneting to my system, the server memory grow and grow on... Until the memory is out (I have 2 Gb in RAM).
>How I can fix this trouble?? Maybe I have to compact my database or reindex my tables?? Or more memory???
>
>My first action will be format my server (DELL PowerEdge 4400 866MHz XEON dual) and install SQL sever again.
>I hope your comments can help me in this situation.
>
>Kind Regarding
>
>Sergio.