How to display intermediate prints when you run a large script in MSSQL MS?
There is a great script that shovel a lot of data.
I wanted to see the steps in this script, which added in the right places prints with the date, but when you run this script in the Studio all the results are displayed after execution of the query.
I.e. if the script runs for 5 minutes, then print step, which was performed 2 minutes ago I will only see the completion of the whole script.
I tried to group the queries in begin/end, didn't help.
Option to write the script execution time in the table not to offer, since you want to display the results in the console.