>I am pulling down several large tables from an Oracle database and was wondering if anyone has come up with a means of showing the progress for this sort of operation. I have tried the "timer" route but it looks as if the timer events get put into the queue as the "SELECT" query eats up the cpu time. Any ideas?
>
>Thanks,
>George

Hi George,

You can show an AVI before you start your query and shut it down after it finishes. It doesn't give you a progress bar, but at least the user has some idea the program is still busy doing something. I've used a AVI called transmit.avi (think it comes with VS) that shows two computers connected through a pipe and a little red ball comes back and forth between them.

The other thing is to run the SPT asynchronously, set the number of records to bring at a time and do something in between the packs. It turns out to be the same deal as with the AVI, because in either case you don't know how many total records are coming to show a progress bar. Unless you're doing a "TOP nnn" query.

Fancy meeting you here. Hope you're doing good.