'Avoid newline when using raiserror

Suppose I debug using raiserror, like so:

raiserror('Trying to do something...',0,0) with nowait

(queries that do something)

raiserror('Done.',0,0) with nowait

It would be handy to have this output in the "Messages" of SSMS in a single line:

Trying to do something...Done.

Is there a way? I haven't found anything around

sql-servertsqloutputraiserror


Solution 1:[1]

No, either you wait until both actions are complete and print a single line with one call, or you have the output on two lines. SSMS (and ADS) just aren’t equipped to do what you want to do.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Aaron Bertrand

Related Questions