Using T-SQL RAISERROR with NOWAIT to provide information on long running stored procedures
If you are trying to determine how long the various statements in a stored procedure are taking, then you really need to see output in real time (i.e. not wait till the end).…