SDU Tools: Print message without delay in T-SQL
When you are trying to debug code in SQL Server T-SQL, or trying to monitor where code is up to, it’s common to add PRINT statements into the code.
These are fine when they are ad-hoc statements, but if you include PRINT statements in stored procedure code, and the procedure runs for any length of time, you’ll know that you normally don’t get to see the PRINT output in the Messages tab until the procedure ends.
And by then, it’s really too late.
In our free DBA and developer SDU Tools, we added a tool to make it easy to get messages immediately rather than waiting.
PrintMessage sends a message to the Messages tab in SQL Server Management Studio immediately.
You can see it in use above in the main image and here:
For more information on our free SDU Tools and to join our SDU Insiders to get more information on our tools, eBooks, webinars, etc. please just visit here:
http://sdutools.sqldownunder.com
2018-05-23