>Thanks for you help Sergey. This doesn't work because my sp does not return a result set. What I am trying to do is display an animated gif while the sp is doing its work but the gif stops animating while the sp is running.

Hi James,

I missed part about sp, sorry. Take a look at Progress Bar Class Example FAQ #27458. It seems exactly what you're looking for.