The pepper spray is not for my dog. It’s for someone else’s dog who is unleashed and on the loose.
I don’t mean to be harsh but you are essentially telling us that you have no control over your dog. You need to be walking your dog on the leash around your back yard everyday training him to walk at your side not pulling you along. I’ve done it with my dogs. Its a pain in the azz but necessary.
My dogs do what I tell them. Half the time I just point at the pet bed and they slink over and get in. If they start to beg at the table I just point to the entrance to the dining area and they go sit there.
Either you’re the boss or your dog is.