how to capture PRINT statement from stored procedure in VB?

[dklions]

Hi,
how can I capture PRINT statements from my stored procedure in Visual Basic (SQL Server 2000/VB6)?
I'm using ADODB.Command object.

I have a set of stored procedures that have a bunch of print statements in them. I need to capture those statements into the LOG FILE.


Please Help!

Thanks!

 

[cheyney]

Look at this post:

http://www.experts-exchange.com/Pro...ges/Visual_Basic/VB_Databases/Q_10205690.html

You might need to create a temp table at the beginning of each sproc, insert into it instead of issuing print statements, then select all inserted rows from it and return it as a result set to you VB program.

Cheyney