Allen,

Yep, I know they will appear in the Message window. That's what I want to happen. But they all appear at once, not as they occur in the WHILE statement.

I ran it for one day, the results showed up in 4 minutes. I ran it for 10 days and never saw a result until it finished 30 minutes later.

-SQLBill