Transact-SQL: Echoing stored procedure status during run rather than getting all print statements at end.
Posted on 2003-11-03
I have a stored procedure that executes several other stored procedures, some of them with fairly lengthy run-times. I would like update statements to print between the sub stored procedures. I have print statements between them but what happens is that all of my 'update the user' statements, both from within the sub stored procedures and the main procedure, are printed when the main stored procedure is completely done running.
I currently run this through SQL Query Analyzer but am more than willing to switch to something else if that is what it takes to get run time updates.
CODE from sp:
print "Renaming the old table..."
execute sp_Rename CurrentMonth, @previousMonthName
print "Creating the CDT . . . "
print "Done. "
print "Updating the CDT . . ."
print "Indexing the CDT . . ."