Hi, thanks for the replies. The purpose is to see which stored procs are still in use and perhaps get an indication of how busy they are, so we...

That's excellent, thanks.

You've got WAITFOR in there, is that just for illustration? Otherwise it could go in the catch block where you decrement the retry count presumably?

Thanks chaps.

Not sure how you'd tackle a deadlock. Can you retry within the same SP somehow?

No one's mentioned timestamps.

So you don't do a try - catch when only updating one table? What does your try-catch block look like when you do use one?

Also, do you use timestamps?