How see output from print statement when sp called from JDBC

Question

How see output from print statement when sp called from JDBC

Sean Elliott

Old Hand

Points: 391
More actions
July 29, 2004 at 8:55 am

#85935

Hi
If you put helpful debugging print statements in your TSQL how do you get to see them when you execute the stored procedure from something other than Query Analyzer e.g. from a JAva program.
I think they might be appearing on a console somewhere? If so how can you see that remotely?
Thanks
Sean

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Stokes SSCrazy Eights Points: 9861 More actions · Answer 1

Can you not cycle through the recordset and use the print statement for the application in the debug window?

I often do this in vb. Alternatively, you can insert the recordset into a temporary table or a text file and see what that brings back.

------------------------------
The Users are always right - when I'm not wrong!

Sean Elliott Old Hand Points: 391 More actions · Answer 2

It is not a result set that I am printing via PRINT statement - it is debug trace information.

Sean Elliott Old Hand Points: 391 More actions · Answer 3

I think you can cheat and just look at the SQL Server error log file which includes console output (i.e. your print statements). Not 100% sure since I haven't got permissions on the box (yet). The error log file is usually in:

c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

Clay_G Default port Points: 1454 More actions · Answer 4

In ADO, Print text appears in the Errors collection:

DBConn.Errors(n).Description

There might be difficulties with timing - they might only appear after the recordset (all recordsets?) is fully retrieved.