General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Web Publishing Error
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only