Viewing print statement output from JDBC

  •  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?



  • This was removed by the editor as SPAM

  • SQLDMO is the only way I have seen it done. See

  • 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

  • Call getWarnings() on the Connection, Statement, or ResultSet prior to closing.

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

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