Z
Z
zhaar2019-04-01 11:32:53
Microsoft SQL Server Management Studio
zhaar, 2019-04-01 11:32:53

How to display intermediate prints when executing a large script in MSSQL MS?

There is a large script that shovels a lot of data.
I wanted to see the execution steps of this script, for which I added prints with the date in the right places, however, when this script is executed in the studio, all the results are displayed after the request is completed.
Those. if the script has been running for 5 minutes, then I will see the print of the step that was completed 2 minutes ago only after the completion of the entire script.
Tried to group requests by begin/end, didn't help.
Do not offer the option to write the script execution time in the table, because. you need to display the results of the work in the console.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Konstantin Tsvetkov, 2019-04-01
@zhaar

NOWAIT .

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question