Please add a new variable called "message" in the query results section that captures the message output from the query.

see:

http://stackoverflow.com...procedure-to-c-sharp-app 

We would also like this, it is useful for debugging SQL related issues

the behavious should be just like running stored procs using SQLCMD.exe. This outputs the message (PRINT statements) to the console. so maybe this should all go to STDOUT rather than a seperate Message variable.

Having this opportunity is good, but if the message is to be displayed in the general output, it must be an on-off switch with default off. Then you can switch it on when you need to debug. Without this switch a lot of existing code out there will fail. Imagine if you have print statement in you procs, and they suddenly show up in the output, and the next task checks output for results => disaster.


Thomas

This has now been added in latest beta. https://www.visualcron.c....aspx?g=posts&t=7604 

Both as an option in SQL output and as a Variable;

---