Thanks for the responses, I do appreciate the input.

More information:

My stored procedures are preface with "usp_".

I used the same login to run the procedure in Query Analyzer that the web...