>Task manager reports 75% of SQL Server memory. Can I send you a Image of this situation to believe me??? Tell me how??
I believe you. BTW this may not be a problem if the server is dedicated to SQL Server. SQL Server 7 & 2000 will manage memeory as needed. You can configure it but MS suggest that you just let it be.
>I thing that every conection to my SQL server, requires about 20Mb, if I have 30 users max., is around 700Mb including SQLserver.
You can't assume that the working set size divided by the number of connections is the amount of memory that SQL Server is using for each connection. The data cache will consume most of the memory. There are various perfmon counters that you can use to get an idea of what going on.
-Mike