I'm using a SQLServer 6.5 stored procedure and I call it from VB 6.0. The stored
procedure fails, loses the values in the variables that it uses. I tested in several ways,
but it does not function properly. The results are incomplete.
The store procedure must generate N records in a table while making comparations.
I think the comparations are failing, due to a memory problem (with 64 MB?) and
that the variables are losing its values, because it generates only N-70 records.
If I run the stored procedure outside VB 6.0 it functions well. Can you give some advice?