CODEWITHSUNDEEP
sql-servert-sqldebugging
Paul Keister
Paul Keister

Reputation: 13097

Flush SQL Management Studio Message Buffer

When I use PRINT statements to debug and monitor long running queries in SQL Server Management Studio, I notice that the output does not appear in the Messages tab right away. Is there a way to flush output to the message tab, or to set up the environment so that it doesn't buffer messages?

Upvotes: 1

Views: 5465

Answers (1)

Martin Smith
Martin Smith

Reputation: 453897

Use RAISERROR with NOWAIT instead of PRINT http://www.mssqltips.com/tip.asp?tip=1660

Upvotes: 5

Related Questions