TSQL : How to get messages sent first class - SimonS Blog on SQL Server Stuff

TSQL : How to get messages sent first class

Leo has posted a great tip about how to get messages output in a TSQL batch without waiting until the batch completes. The trick is to use RAISERROR with a level of 0

http://sqlblogcasts.com/blogs/leopasta/archive/2007/07/03/instant-gratification.aspx


-
Published 03 July 2007 00:25 by simonsabin
Filed under: ,

Comments

04 July 2007 06:14 by Julian-Kuiters

# re: TSQL : How to get messages sent first class

I've taken Leo's code and wrapped it into two easy to use stored procedures to save time.

You can download them from <a href="http://www.julian-kuiters.id.au/article.php/sql-snippet-instant-print-time">http://www.julian-kuiters.id.au/article.php/sql-snippet-instant-print-time</a>