Getting the message below when I execute an INSERT INTO via SQL 2000
SP3a. I do NOT get this message when running in SQL 2005 SP1. The
stored procedure completes successfully in SQL 2005 environment.



Was converswion of money to varchar not allowed in SQL 2000 without
using CAST/CONVERT?



Msg 260, Level 16, State 1, Procedure HOPE_alloc_step3, Line 103

Disallowed implicit conversion from data type money to data type
varchar, table 'DBSallc.dbo.PJLN_LOAD', column 'FIELD25'. Use the
CONVERT function to run this query.





Jeff




MS Sql Server LazyDBA home page