VBA executed SQL stored Proc -- row limitation
Posted on 2009-07-07
I have an SQL stored procedure that uses a cursor to cycle through records in a table and perform various tasks. When I execute the stored proc in Management Studio, it works properly. However, when I execute it from VBA (Microsoft Dynamics GP), it processes the first 128 rows and then stops. It doesn't throw any errors -- it simply stops processing after it has finished 128 records. Is there a buffer problem or something that could be causing this?