The PRINT debug messages from my top-level stored proc are getting piped to my OUTPUT file, however any child procs are not getting piped to the same output file.
EXAMPLE:
I have the following SQLCMD command running a command prompt with -o output param:
sqlcmd -S %myServer% -E -d testDB-Q "exec dbo.sp_Testme" -o Output\Test_All.log
I noticed that the PRINT messages from my "sp_Testme" stored proc are successfully getting outputted to the Test_All.log file; however, sp_Testme makes an additional stored procedure call to "sp_Testme_Details" .
The problem is that any PRINT message in "sp_Testme_Details" are NOT making it into my Test_All.log output file.
Am I missing out on something ?
Thank you,
Bob