Post reply

Viewing print statement output from JDBC

  • July 29, 2004 at 9:08 am

    #108759

     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

  • August 2, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • August 2, 2004 at 5:21 pm

    #517350

    SQLDMO is the only way I have seen it done. See http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=22&messageid=122842#bm122878

  • August 3, 2004 at 3:03 am

    #517395

    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

  • August 22, 2007 at 3:21 pm

    #728729

    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