Wow. Almost sounds neurologic...pinched nerve possibly? In the many years I have worked for vets, this is not all that unusual. We often put the pets on steroids and maybe tramadol, similar to what RamTX's vet did. If your vet does this, there will have to be a "wash out" time of 4-6 days, to get the nsaid out of his system. He might find some relief from acupuncture, cold laser therapy or chiropractic adjustments. Continue to work with your veterinarian, but keep him quiet as he recovers...Usually, 2-4 weeks, depending on the situation. If he is dragging the top of his foot, a boot over that foot may help. Good luck. Most dogs seem to recover in time. And yes, a home sitter is probably in his best interest in the future.