I have a procedure which runs fine on our old SQL 7 database but which refuses to run on our new SQL 2000 database. This proc involves selecting a timestamp value out of a table that is a binary, and inserting it to a column in a temp table that is declared as a datetime. When I run the proc on the new server, I get the following error:
Server: Msg 210, Level 16, State 1, Line 7
Syntax error converting datetime from binary/varbinary string.
Is there something else I have to do to make this conversion work on SQL 2000?
Server: Msg 210, Level 16, State 1, Line 7
Syntax error converting datetime from binary/varbinary string.
Is there something else I have to do to make this conversion work on SQL 2000?
