Jeff, thanks. Yes, this makes sense and would certainly explain why my @@lock_timeout=-1 setting has been a no-go for me.

Dan

Huh? Turned off your pager? Shame on you, Lynn. Blasphemy!

Didn't you know that resistance is futile? You MUST assimilate.

Lynn,

Yup, that is correct, I want my jobs to wait infinitely, hence I set @@lock_timeout to -1 for infinite wait, just like BOL says I should do. If this...

OK, based on the two posted responses thus far, some more clarification regarding my question is obviously required …

- I’m not asking about what a deadlock is (been doing this...

CDP -- Continuous Data Protection

Anything with point-in-time recovery is nice.  But make sure you need this as a requirement.

Dan