Viewing print statement output from JDBC

• Sean Elliott

  Old Hand

  Points: 391

  More actions

  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

• Antares686

  SSC Guru

  Points: 125444

  More actions

  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

• Sean Elliott

  Old Hand

  Points: 391

  More actions

  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

  

• Scott Rachels

  Valued Member

  Points: 53

  More actions

  August 22, 2007 at 3:21 pm

  #728729

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