DavidLemire
Programmer
Hi friends,
This is my first post on this forum, as I've just registered for TekTips. I hope you are a great community, and if that is the case, I'll do my best to keep this community healthy!
Ok, down to the point. I have an Excel report that calls a stored procedure. This SP then returns multiple result sets to the ADO object. However, I have this problem. Depending on the timeframe selected, the time to run the SP can expand from 20 seconds to about 10 minutes. In Query Analyzer, I can monitor easily the progress of SP by adding some "Print" statements. I want to know if it's possible to return those "Print" statements as the SP progresses, to the ADO object, so I can display those statements in Excel (like a progression).
Any help on that would be greatly appreciated !
--
David Lemire, Consultant
This is my first post on this forum, as I've just registered for TekTips. I hope you are a great community, and if that is the case, I'll do my best to keep this community healthy!
Ok, down to the point. I have an Excel report that calls a stored procedure. This SP then returns multiple result sets to the ADO object. However, I have this problem. Depending on the timeframe selected, the time to run the SP can expand from 20 seconds to about 10 minutes. In Query Analyzer, I can monitor easily the progress of SP by adding some "Print" statements. I want to know if it's possible to return those "Print" statements as the SP progresses, to the ADO object, so I can display those statements in Excel (like a progression).
Any help on that would be greatly appreciated !
--
David Lemire, Consultant