CODEWITHSUNDEEP
sql-servert-sql
Farhad-Taran
Farhad-Taran

Reputation: 6540

Can you print messages from within a transaction?

Hi Im trying to use PRINT or a none fatal RAISEERROR to print messages while my transaction is running but they will not print until the transaction has ended. is there any way to actually print a message from within a transaction?

Upvotes: 3

Views: 2258

Answers (1)

muhmud
muhmud

Reputation: 4604

I think you'll find it's buffering that's preventing the messages from printing.

Try:

raiserror ('hello', 0, 0) with nowait

Upvotes: 5

Related Questions