PDA

Click to See Complete Forum and Search --> : how to get the 'debug info' from a stored procedure


Sep 17th, 2000, 02:53 PM
Hi,

Is there a way to get the text that was printed by a stored procedure using the

print 'text blablalba '

command in vb, when using ado as db-connector?

i'm using sqlserver 7 as database.

thanks,

Matthijs Vader

JHausmann
Sep 18th, 2000, 01:34 PM
I don't believe so. Nothing from preventing you to output the debug information to another table (set up specifically just to take the information) that you could then query...

Assume the table has two fields, lineno and text, your stored procedure would want to, at the start, clear any entries in the table.

then, instead of print "text", you'd want to have:

insert into table values (#,"text")


where Number is a value set by you representing the line.

Sep 18th, 2000, 02:10 PM
Thanks! too bad it isn't possible.

Matthijs Vader