I ran into a similar problem with a stored proc being run from my asp.net application. Like yours, it worked in query analyzer and returned results...but nothing was displayed in...
Thanks for the reply. I took a quick look at the article and I don't believe that the servers are set up as case-sensitive. I can verify this later,...