The effectiveness of the spray will depend on the dog's behavior and the specific spray you use. Some sprays may provide a temporary solution, while others may help your dog to stop peeing permanently. You should consult a veterinarian or a professional trainer to determine the best approach for your dog.