How do I fix a loose hanging spray hose from my very expensive long neck kitchen faucet?

What brand and model faucet do you have? Back to you, Tom

Hose should be loose hanging with weight attached to it. Can you be more specific ? Back to you. Milo