view the 'printed' text from a stored procedure

Hi,
Is there a way to see the text that was printed by issuing the
print 'textadfasfasd'
command in a stored procedure from sql server 7,

with an ADO object.

Thanks,
Matthijs Vader

I usually make myself a debug table and write messages there.

Brian

Brian T. Wiehoff