Search code examples
sql-servert-sqloutputraiserror

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

Solution

  • 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.