John,

Thanks for the thought. When we run the procedure with the same parameters that failed on the scheduled job, it works. So it's not a data problem....

'It worked on my machine' drives me nuts. Not because it isn't helpful in determining the problem, but because most developers who I have worked with use it as...

Just a quick thanks. We were able to recover by extracting all the data into a new database.

Mike

Thank you for the advice. Since I am not really comfortable using DBCC PAGE (although it sounds fun to play with on the backup) I'll start with testing extracting...