Hi,
I have a VB6 application where I am calling a SQL Server 2000 stored procedure.
When I execute the stored procedure using query analyzer
it works fine, however when I executed from the VB
application using ADO it would execute and fail somewhere.
I removed all my print statements and set nocount on and the stored procedure executed fine.
So it seems that some buffer is running out of space.
Is there any coding consideration that I need to make
when calling a stored procedure that has debug
print statements.
Thank you
I have a VB6 application where I am calling a SQL Server 2000 stored procedure.
When I execute the stored procedure using query analyzer
it works fine, however when I executed from the VB
application using ADO it would execute and fail somewhere.
I removed all my print statements and set nocount on and the stored procedure executed fine.
So it seems that some buffer is running out of space.
Is there any coding consideration that I need to make
when calling a stored procedure that has debug
print statements.
Thank you