>Hello all,
>
>I have an object called progressbar that is nothing more than a timer that advances a container width over and over again. I would like to call this when I have large queries that will take a long time to run. The problem is that when I issue a select statement the timer on the progress bar stops and doesn't start again until the query is finished. Is there anyway that I can keep the timer running while the select statement is being processed?
>
>Matt

You can not use your progress bar during SQL. The only way is to do it through UDF, but it would slow down SQL dramatically. However, the simplest way to show some progress bar is to do SET TALK ON before executing select and SET TALK OFF after.