July 29, 2004 at 9:08 am
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
SQLDMO is the only way I have seen it done. See http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=22&messageid=122842#bm122878
August 3, 2004 at 3:03 am
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
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