MS SQL 2005 Client excessive memory usage

MS SQL 2005 Client excessive memory usage

Hi I inherited the support of an MS SQL 2005 server on a Windows 2003
server and its client XP workstations running MS SQL 2005 Native client.
The database is appox. 1GB in size and some of the tables contain several
thousand records.
The problem I now have is that when the client (OLEDB) applications access
the server to create an new customer for example their memory usage peaks
out at 1.23GB whilst performing the task. On some workstations they simply
run out out memory and the operation fails. I have loaded an earlier much
smaller copy of the database and when running that the memory usage is
less then 50MB. So memory creep seems to be related to number of records
in the database. What can I do on the client workstations to determine
what is using the memory and how to reduce the memory usage. Any advice
would be greatly appreciated. Many thanks. Arthur