>Yeah, I've just ran more tests, I shortened the timer to 1 second and it took 3 hits on the timer before it updated correctly.
>
>You've probably hit the nail on the head. I have tried using FLUSH and it didn't seem to speed it up.
>
>What's the best solution?
>Kev
Check your settings for SET REFRESH. Look in the help, the 2nd (nSeconds2) argument may apply here. The default is 5 seconds. Lower numbers make updates occur faster, but increase i/o and net traffic.
Jim Saunders
Microsoft
This posting is provided “AS IS”, with no warranties, and confers no rights.