Great!! Thank you all. I think we figure out at the same time you guys were responding. Thank you anyway. I run it with the @@error for each statement in the sp and it seems to work. The developers will run it tonight the the big job they designed and hopefully it will work. Thank again