Memory Low after running for a day

A program is used to insert data record by record to a SQL Server (2000)
using transaction. After a day, 300M or memory was used up. What would be
the cause of such "memory leak" and how to releasing the memory other than
reboot? Thank you.> A program is used to insert data record by record to a SQL Server (2000)
> using transaction. After a day, 300M or memory was used up. What would be
> the cause of such "memory leak" and how to releasing the memory other than
> reboot? Thank you.
This is not a memory leak, this is how it has to work. SQL Server caches
execution plans and the data, grabs memory when it needs it, but releases it
only on a demand. If you have to, you can limit the memory SQL Server uses
with the maximum memory configuration option
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org