Re: select 'message'; not appearing
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Tue, 15 May 2007 21:37:39 +0000 (UTC)
Jeff Kish (jeff.kish@xxxxxxx) writes:
I am trying to add some debug to a stored procedure.
I put some statements like this throughout the code:
select 'some message here';
but I never see them.
I put them in a test procedure that works fine, so that I have a feeling
that when an insert fails in a down-stream try catch block, it messes up
the display of the information.
Can someone tell me how to best go about outputting debug I can see from a
stored procedure, or if I am even correct about try catch blocks throwing
errors, messing up the debug visibility.
I don't have any experience of the TRY-CATCH block messing up the output.
If the debug SELECT does not appear, my interpretation is that the
SELECT statement is never executed. That is, you never reach that part
of the code.
Seeing the actual code would make it easier to say what is going on.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: select 'message'; not appearing
- From: Jeff Kish
- Re: select 'message'; not appearing
- References:
- select 'message'; not appearing
- From: Jeff Kish
- select 'message'; not appearing
- Prev by Date: select 'message'; not appearing
- Next by Date: Re: approach to creating a procedure that contains dll , dml to upgrade a system
- Previous by thread: select 'message'; not appearing
- Next by thread: Re: select 'message'; not appearing
- Index(es):
Relevant Pages
|
