February 26, 2007 at 10:04 am
Hi I have a SP which calls 14 other SP's.
How can I display either in the results or messages tab when each SP has finished. I have tried adding Print and Select statements, but they always seem to all appear when the master SP has fully finished executing....
I have put set nocount on statements each invidividual procedure as I don't want to view the quantites being processed. I have also added Select and print statements in each SP and also in the Master SP.
Any ideas?
i.e Print 'SP_1 successfully created: ' + cast(getdate() as varchar)
select 'SP_1 successfully created: ' + cast(getdate() as varchar)
February 26, 2007 at 2:33 pm
Throwing in PRINT statements is the way to monitor the progress. Do you have SET NOCOUNT ON on the main proc? If so you need to remove it. Other than that you can probably write the status message to a table and query that constantly..
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
February 27, 2007 at 7:13 am
What happens if you change your options to scroll results as received?
Tools, Options, pick the Results tab and check "Scroll results as received (*)"
Brian
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply