SQL Server doesn't responses!

Hello

I have a program that inserts records to a SQL Server 2000 Database, it inserts the records through a Stored Procedure, the program calls the Stored Procedure a lot of times.

The problem is that the memory that SQL Server uses begins to grow constantly while the program is running until it uses all the system memory !!!

Then SQL Server doesn't response and the next insert calls fail.

The Stored Procedure is created only one time at program startup, and when I need to call it I pass only the parameters and execute it, I do it with an ADO Command

The program is developed in VB 6.0 with ADO 2.5+

How I can fix this?

or Do I have to change something in the way I do the process?

Thanks

You could setup a trace on the SP using the included SQL Profiler tool. That will give you a bit more info about what exactly is happening when your query runs.