OK I will do that. Cheers for your help.

I agree that the "limit" it is showing is the same as the maximum value SQL can handle and they mean the same thing. I'm just curious as to...

Steve,

Thanks for your quick reply. The waitfor will be very useful. However, the main challenge is how to get the update done in batches so if it does...