how to get the 'debug info' from a stored procedure

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

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.

Thanks! too bad it isn't possible.

Matthijs Vader