In creating a new Web Assistant Job, I am selecting a stored procedure which runs fine when executed in Query Analyzer. However, setting up the Web Job with this query produces the error "Error converting data type varchar to datetime." I've poured over the SP itself and delved into the data but have not found the reason yet why the SP that otherwise runs fine produces this error when called through Web Publishing.

Does anyone know of a issue with Web Publishing that might be causing the error? What else might the issue be?

Thank you.


Todd