Stored procedure return status question.
Posted on 2008-11-10
I have a long stored procedure, inside this procedure, it created some temp tables and populate to a table with the data selected from these temp tables, and it will take several minutes to execute this procedure (to populate the table with the selected results takes that much time). Everything works fine except I want a return status to show the procedure is finished running (after several minutes). But when I execute the procedure, it just showed how many rows are updated, etc. there is no end of execution information when the procedure exits. Even when I add one line: print 'Done' at the end of the procedure, there is still no output 'Done' printed to screen at the end of running the procedure. Please advise. Thanks.