>> but if your stored proc returns the value
>That's the problem, it doesn't :o(
What happens if you issue this in QA?
Try this, make a SP in your DB that will do only this:
SELECT @@SERVERNAME, and call it from your front end.
Did this helps?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.