I have run into the following problem: I am trying to call a SQL Server stored procedure from VB but the
procedure only handles a few records and then just stops. I have tried extending the value of the 'commandtimeout' property of the ADODB command that executes the stored procedure, and even tried eliminating it entirely, but these changes made no difference. The stored procedure runs fine when run directly in SQL Server.
Does anyone know what the problem might be?